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!

Ambiguous Relationships | Microsoft Fabric Community

Greg_Deckler
Community Champion
5 years ago
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
Continued Contributor
5 years ago
Hi DauletKali,

Between which tables are you trying to create a relationship?

Best Regards
Simran Tuli
- DauletKali
  Helper I
  5 years ago
  Hi there,
  Between Dims which are underlied by black and red colours and two table which are above these dims ("СпрЗат" and "Calendar")
  - AllisonKennedy
    Community Champion
    5 years ago
    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.