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 DauletKali,
Between which tables are you trying to create a relationship?
Best Regards
Simran Tuli
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.AllisonKennedy - Ah, good catch, many-to-many = bad!
