Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationship ambiguity

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 relati...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    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

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

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