Forum Discussion
Many to Many Relatioship
Hello All I'm Trying to create a report where i have two Table as Error Table and Client Record. Both table have Many to Many Relation and Both as cross Filter Drection . I have tried c...
v-kelly-msft
Community Support
Community SupportHi Anonymous ,
You'd better ceate a bridge table when use many to many relationship,such as below:
Here is the reference. https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
Best Regards,
Kelly
Kelly
Did I answer your question? Mark my post as a solution!
Hi v-kelly-msft.
What you are referring to is not really Many-to-Many. It's an example of a granularity problem.
So it's not the pattern of M2M:
Table1 1:* Bridge *:1 Table2
but a completely different one:
Table1 *:1 DistinctValues 1:* Table2.
This is not Many-to-Many. It's a granularity issue and can be solved easily without the middle table. You can join directly the fields from Table1 to Table2. You then get something that's known as a weak relationship and is enough to solve the problem.
Best
D