Ambiguous Relationships

[DauletKali]

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. 

[Greg_Deckler]

@DauletKali - This generally means that you have 2 paths between tables. It should create the relationship but it will be marked inactive. You can use it in a calculation however by using USERELATIONSHIP.

[simrantuli]

Hi @DauletKali,

Between which tables are you trying to create a relationship?

Best Regards

Simran Tuli

[DauletKali]

Hi there,

Between Dims which are underlied by black and red colours and two table which are above these dims ("СпрЗат" and "Calendar") 

[AllisonKennedy]

@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.

[Greg_Deckler · Accepted solution]

@AllisonKennedy - Ah, good catch, many-to-many = bad!