Forum Discussion
Solved
Ambiguous Relationships
Hello, Cannot solve the problem of ambiguous relationship. When I try to link second relationship (see pic below) it says that it would introduce ambuguity between tables.
AllisonKennedy - Ah, good catch, many-to-many = bad!
Hi there,
Between Dims which are underlied by black and red colours and two table which are above these dims ("СпрЗат" and "Calendar")
DauletKali your Calendar relationships are fine, but what is the СпрЗат Dim? Because this is a many to many relationship with both cross filter direction , it causes ambiguous data.
I have written a series of posts to try and explain why this ambiguity occurs, and why it is important to try to find the unique identifying key columns for the Dim tables.
https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_92.html
There are a few reasons it's ok/needed to use a many to many, but without knowing what your Dim represents, I can't tell if this is one of those cases. Let us know and we can help troubleshoot further.
I have written a series of posts to try and explain why this ambiguity occurs, and why it is important to try to find the unique identifying key columns for the Dim tables.
https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_92.html
There are a few reasons it's ok/needed to use a many to many, but without knowing what your Dim represents, I can't tell if this is one of those cases. Let us know and we can help troubleshoot further.
AllisonKennedy - Ah, good catch, many-to-many = bad!