Ambiguous relationship issue, please help.

[akashpadmakumar]

In this for the table "Availability planning" I have 3-4 relationships with "GradeMapping", "DIM Calender" , "Month Standard hours" and "Week Standard hours" with this I have actually come with a visual as well.

Now I am supposed to add another table to the same visual "WRBE" which has the same things as "Availability Planning" -

Like - "Grade" to map to "GradeMapping Table" and also Date to map to "DIM Calender"

the issue is, I can successfully map "WRBE"  - realtionship "Date" with the "DIM Calender", but If I try Grade as well- it shows an ambiguous realtionship

I am aware it is because I am already having a relationship with the "Availability Planning" hence not able to make that relationship.

Is there any work around ?, as I have filters from the Availability planning applied on the visual which should change with WRBE as well

[Anonymous · Accepted solution]

Hi @akashpadmakumar ,

Based on the description, have you added another table to the visualization that has a relationship to the WRBE table?

If the content of the other table is the WRBE table, it is able to map the grade to the Grade Mapping table.

What’s more, try to create the inactive relationship.

Besides, you can also view the following document to learn more information.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Solved: Relationship ambiguity - Microsoft Fabric Community

Solved: Ambiguity relationship - Microsoft Fabric Community

Solved: Power BI - ambiguous relationships - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

why are all these relationships set to 'both' direction?

[akashpadmakumar]

no specific reason, if I make them all uni directional I can make this relationship work ?