Forum Discussion
How do I create multiple relationship paths between 2 tables?
Hi everyone,
I'm trying to connect 3 tables together and came across the error that I can't create the relationship between table 1 & table 3 because it would create ambiguity between table 1 & table 2.
It seems to be the same as this problem:
but i'm still not sure on how to go about fixing it.
Here is the file for reference: link.
Thank you!
3 Replies
- amitchandakSuper User
Anonymous , I do not have access to the image. Make sure there no two paths. Means A- B -C and A-C
- AnonymousNot applicable
- v-xuding-msftCommunity Support
Hi Anonymous ,
May I ask you why you want to create multiple relationship among the tables? If it is because of calculations, you could try to create a start schema and use crossfilter() to implement.
Understand star schema and the importance for Power BI
Bi-directional relationship guidance
Model relationships in Power BI Desktop
How to manage ambiguous relationship in Power BI
Why Is My Relationship Inactive in Power BI Desktop?