This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 80%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
I am migrating from SSAS Multidimensional to Tabular. However I faced a problem related to filtering dimension. While there is no problem filtering a dimension with a related fact, like below:
The filter did not work when no fact is included. Instead, it shows all hours.
It is not the case in multidimensional and it is able to only show the hours that have data.
Similar things happen to invoice number. If the user want to see the invoice issued in a certain day, he needs to include a related fact first, which is kind of counter-intuitive to what a filter should work. Does anyone have similar problem? How should I solve it? Thank you!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 41%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Hi vincent,
I wanted to check if you had the opportunity to review the information provided and resolve the issue..? Please let us know if you need any further assistance. We are happy to help.
Thank you.
Hi vincent,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
Hi Vincent, Thank you for reaching out to Q&A Forum. In SSAS Tabular, unlike Multidimensional, unrelated dimension members still appear when no fact is used. To fix this create a DAX measure like: Has Sales Data = IF(CALCULATE(COUNTROWS('FactSales')) > 0,1,0 Then use it as a visual filter and show items where the value = 1. Alternatively set the relationship's cross filter direction to Both for automatic filtering. You can also build a calculated dimension table showing only members with data. These methods make slicers and visuals display only dimension values that have related facts - replicating Multidimensional behavior.