Forum Discussion
Solved
The relationship has cardinality Many-Many.
Hi Team @,
I have two tables with a unique customer id for lookup. And in the relationship table, it matches perfectly but the value for all account fluctuation same.
Please find the image for a better view.
Try adding a calculated table and using many-to-one relationship.
https://community.powerbi.com/t5/Desktop/Unique-values-from-two-columns/m-p/468317#M217488
1 Reply
Try adding a calculated table and using many-to-one relationship.
https://community.powerbi.com/t5/Desktop/Unique-values-from-two-columns/m-p/468317#M217488