Forum Discussion
Help linking tables together - ambiguity
Hi, I am a long time Excel user coming over to Power BI. I definitely see the potential with Power BI and love what it can do. However, I am struggling with its strict table relationships and unsure...
Anonymous based on your requirement, i think the relationship between employee and interaction is not required. and make relationship active between org and employee.
Anonymous -
If I understand your requirements correctly, you could remove the relationships to org, and instead make a relationship between org and interactions.
So interactions would be the fact table, and org, emp, and client are dimension tables.
Then you can use DISTINCTCOUNT on empid and clientid from the Interactions Table, and use org name from the Org table.
Cheers!
Nathan
parry2k
Super User
Super UserAnonymous based on your requirement, i think the relationship between employee and interaction is not required. and make relationship active between org and employee.