Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When I am using the multidimensional cube in power bi to direct query.
I am using Star Schema in Data Warehouse
when I use two different dimensions as a filter for eg. 1) DimGeography (Country) and 2) DimItem (ItemName)
every Item name is different every country.
So when I filter country lets say 'US' in the First filter than in the Second filter I am getting the all Item Name for all country.
But the Fact is getting filtered its is showing Sales on basis of 'US' with all the US Item Name.
So when I will give country wise permission to respective business users to view reports they will be seeing other countries Item name as well in the DimItem filter, so that won't make sense.
How I can filter ItemName when I filter Country name.
@rgirotra,
When you put the two dimensions into seperate filters, filtering one dimension will not affect the other dimension, this behavior is by design.
Only when you put the two dimensions in same visual, the relationship between them can be established, and one dimension can filter another dimension properly. There is a similar thread for your reference.
http://community.powerbi.com/t5/Desktop/Cross-Filtering-with-Multi-Dimensional-SSAS/td-p/167575
Regards,
Lydia
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |