Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am confused on the relationship between role playing dimensions and USERELATIONSHIP. At first I thought using USERELATIONSHIP for an inactive relationship was role playing dimensions but then I found it sounded like you needed a create separate calculated tables for each measure you wanted to use.
I have read the following articles and posts and I am still unclear:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema#role-playing-dimensions
https://data-mozart.com/welcome-to-powerbi-thetare-role-playing-dimensions/
So it sounds like if you have a table with multiple measures you want to use for the relationship, then you create copies of the tables and each will have a different relationship with the single table. Is that it?
@PeterL33 If we look at your example, the challenge with individual tables will be on how to show data on the same x-axis:
for example, if I want to see an order received, shipped, and due by month, I will not have a common dimension to achieve this and will not be able to produce the expected output. That means I need a common date table with inactive relationships to make it work. In general, it is rare you will have duplicate dimension tables.
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.
@PeterL33 not fully sure what you are referring here, can you give an example:
I found it sounded like you needed a create separate calculated tables for each measure you wanted to use.
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.
This is what I am interpreting from the articles:
"If having multiple relationships between two tables is causing the creation of inactive relationship, one way to avoid it seems to be creating multiple instances of the same table, and then you would need only one relationship not more than that."
"To overcome these limitations, a common Power BI modeling technique is to create a dimension-type table for each role-playing instance. You typically create the additional dimension tables as calculated tables, using DAX. Using calculated tables, the model can contain a Date table, a Ship Date table and a Delivery Date table, each with a single and active relationship to their respective reseller sales table columns."