Forum Discussion
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...
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
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".