Cross Filtering with Multi Dimensional SSAS

[Beckster]

Hi

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).

[v-sihou-msft]

@Beckster

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.

Regards,

[christian_mal]

Hello,

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

example:

Thank you
Regards,
Christian