Relationship ambiguity

[Anonymous]

Dear all,

After searching arround and not finding a clear solution, then I decided to ask here.

I have two data tables with cost and cost forecast and then I would like to create a relationship with both tables to the look up table GL accounts. However, I am getting the Relationship ambiguity error as pictures attached. What am I doing wrong?

Best regards,

Beto

[Anonymous]

Thank you all!

I had a bi-directional relationship and that was the issue. It got fixed as soon as I changed it to "single". 

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Would you please check your data model if your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.

As a workaround, I suggest you use LOOKUPVALUE function to get data from GL accounts table.

For more details, please refer to https://radacad.com/what-is-the-direction-of-relationship-in-power-bi

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , If there two paths getting created then you will get this type of error

That can because of bi-directional relation you some wrong join 

Like A-> B -> C

A->C

There are two paths to C

A<-> B

A<-> C

Now if try have more  D with both B and C you will get this error