Forum Discussion
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...
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)
lbendlin
Super User
Super UserHow 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)