Forum Discussion

Beckster's avatar
Beckster
Frequent Visitor
9 years ago

Cross Filtering with Multi Dimensional SSAS

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 iss...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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's avatar
    christian_mal
    New Member
    7 years ago

    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