Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DauletKali
Helper I
Helper I

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. 

DauletKali_0-1599414597501.png

 

1 ACCEPTED SOLUTION

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
simrantuli
Continued Contributor
Continued Contributor

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.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.