How do I create multiple relationship paths between 2 tables?

[nurulraqiah]

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:

https://community.powerbi.com/t5/Desktop/Date-Table-relationship-with-multiple-tables/m-p/584417#M27...

but i'm still not sure on how to go about fixing it. 

Here is the file for reference: link.

Thank you!

[amitchandak]

@nurulraqiah , I do not have access to the image.  Make sure there no two paths. Means A- B -C  and A-C

[nurulraqiah]

Hi @amitchandak, 

I'm basically trying to link these 3 tables together:

[v-xuding-msft]

Hi @nurulraqiah ,

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?