Forum Discussion
Get selected value USERELATIONSHIP (no aggregation)
I found a link which discusses this:
https://community.fabric.microsoft.com/t5/Desktop/Dealing-with-multiple-references-to-the-same-table-without/td-p/2429212
simply the model and create a proper star schema it would be recommended to have two user tables, one will be Sales Owner Users and the other Relationship Owner Users. There really isn't a need to create complexity in measures / visuals / report with a single user table (which usually only have a few hunderd or a few thousand records)So it would be best practice to make multiple references! I probably was overthinking this 🙂
I found a link which discusses this:
https://community.fabric.microsoft.com/t5/Desktop/Dealing-with-multiple-references-to-the-same-table-without/td-p/2429212
simply the model and create a proper star schema it would be recommended to have two user tables, one will be Sales Owner Users and the other Relationship Owner Users. There really isn't a need to create complexity in measures / visuals / report with a single user table (which usually only have a few hunderd or a few thousand records)
So it would be best practice to make multiple references! I probably was overthinking this 🙂
Hi joris-kempen ,
Glad to see that you found the documentation to solve your problem, it will help other users on the community who have the same problem!
Best regards,
Albert He