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.
