Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
I am probably posting a question already raised by many people.
I am building some sales BI. I have configured:
- 1:N relationship between Owners and Accounts
- 1:N relationship between Accounts and Opportunities
However, in my organization, it is possible that an Opportunity belongs to a Owner different from the one owning the opportunity's Account. So when trying to configure a 1:N relationship between Owner and Opportunities I am getting the "ambiguity" error.
I understand I could create a duplicate Owners table. However I would like to be able to list both the owned accounts and the owned opportunites with one selection.
Can anybody suggest a strategy to solve this?
Thanks for your help
Hi,
Show your data and more importantly the expected result.
Hi,
Thank you.
I solved the issue by creating dim tables based on the role. now I am able to filter entities according to different perspectives.
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |