Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Cross Filtering with Multi Dimensional SSAS


We have a new SSAS cubes I am wanting to build some reporting on.

I am wanting to make sure of the existing model etc so am importing as live so I can access the whole cube.


I am finding issues with cross-filtering between dimensions, eg filtering on a field in a dimension correctly filters the measure groups, but related filters (fields from other dimensions within the same cube) are not filtered based on the data selected so am seeing the full data set options.


(eg opportunities dimension is filtered by owner, but the list of related account names in the account dimension still shows all accounts for the entire dataset, not those that should be related to the opportunities dimension).


I have asked the dev building the cubes and he doesn't know what the issue is and says its a power bi problem (and reckons excel is fine) and has no solution.


Anyone else have these issues?


If this doesn't work, I will have to resort to importing the dimensions separately and build the schema again. Whilst this is doable for me (yet a pain), this is not a solution for our 'self-serve' colleagues who don't have the skills to do this via desktop and want to be able to connect to the cubes via online gateway (most colleagues use macs which doesn't have the functionality needed in mac excel).




As I tested, when you put both dimension members into a visual, it will filter the related members properly.








If you only put one dimension in table visual, you must put measure as well so that another dimension slicer can work properly.






However, it find Excel behave almost same way like Power BI Desktop. Please update your Power BI Desktop into latest version to see if it works.





the problem is not resolved because I have the same problem.

1 measure connected with 2 dimension in a multi-dimensional cube

In powerbi desktop, the two slicers do not filter between them.

and on Excel it works very well





Thank you

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors