Forum Discussion

PeterL33's avatar
PeterL33
Regular Visitor
3 years ago

role playing dimensions and USERELATIONSHIP

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 fou...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

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. 

  • PeterL33's avatar
    PeterL33
    Regular Visitor
    3 years ago

    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."