Forum Discussion

petrovnikitama1's avatar
petrovnikitama1
Regular Visitor
11 months ago
Solved

How to avoid cross-join / cartesian product on Pivot table using SSAS Tabular?

  I have an SSAS Tabular model that I connect to through Excel. How can I avoid calculating the Cartesian product when no measure is selected?   In our company, we have Self-Service BI...
Need Help
  • lbendlin's avatar
    lbendlin
    11 months ago
    How can I avoid calculating the Cartesian product when no measure is selected?

    That's not possible. A measure is mandatory for the filters to be applied.

     

    (you could make the links bidirectional but that's generally a bad idea)

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi petrovnikitama1 ,
I would also take a moment to thank lbendlin  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions