Ambiguous relationship loop

Anonymous · ‎12-20-2019

Hi,

I did read a lot of community messages, but I didn't find the solution for my (newbie) problem yet. My Datamodel isn't working, but I cannot think of another solution.

I want to use account and salesmanager as filters in my report. PowerBI is of course erroring with a ambiguous relationship, but how should I solve this in Power BI. As said, I've read a lot of messages, but I can't choose the solution. In the future I want to add Opportunities and all related activities like Calls and so on, but I tried (visit)Reports first.

Thanks for helping out.

parry2k · ‎12-20-2019

@Anonymous relationship should be

Sales Manager -> Report (1:many)

Account -> Report (1:Many)

Not sure why you need relationship between sales manager and account table.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎12-20-2019

I want to show a table, filtered on SalesManager, with records from Accounts.

And a Sales Manager can have a Report with an account where he or she isn't the responsible salesmanager.

parry2k · ‎12-20-2019

@Anonymous so your relationship will be

Sales Manager -> Account (1:many)

Account -> Report (1:Many)

No relaltionship between Sales Manager and Report table

Would appreciate Kudos 🙂 if my solution helped.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎12-20-2019

Thanks for your quick replies!

The possibility is, that the sales manager switches now and then. So when you make the links like you proposed, you can have the situation that a report is shown, where the SalesManager isn't the person who owned the Report.