Forum Discussion
DAX Measure causes Cartesian product in table
Hi all, I'm having trouble understanding why the following happens (and how to prevent it): I have two tables, which I join via a 1:1 relation on a key. th The result after joining i...
Anonymous
When you add columns from multiple tables to a visual, Power Bi creates a crossjoin of these columns producing all possible combinations but hideing the non-existing combinations. By returning a constat as a value you are forcing it to show all the combinations even if they don't exist.
Hey Tamerj1,
Thanks for replying!
If that's the case, how would I then prevent this from happening? Is there any way to detect that it's a non-existing combination (or is there a Power BI setting that let's me always hide non-existing combinations?)
