Forum Discussion
Solved
Solving Ambiguous Pathway Error
Hi, I am an amateur Power BI user trying to create a project managament dashboard. I am running into an issue where i need to have a relationship between two tables, but when i make the join it ...
Hi RileyPilcher ，
You can also try to create many-to-many relationship, but only allow Work Instructions to filter Timesheets.
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Mengmeng Li
Create a bridge table that contains unique values of Work Instruction Number and link it to both the Work Instructions and Timesheets tables.
Create a new table:
WorkInstructionBridge = DISTINCT('Work Instructions'[WI Number])Create relationships:
Work Instructions[WI Number] → WorkInstructionBridge[WI Number] (One-to-Many)
Timesheets[WI Number] → WorkInstructionBridge[WI Number] (Many-to-One)
Use the WorkInstructionBridge table in your measures and slicers to avoid ambiguous paths.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn