role playing dimension for non date scenario's

[Kpham]

Dear experts, I'm want to use role playing for an other purpose then role playing date's. I have a FactSales table that contains 2 keys that describes the relation to a DimensionCustomer table. Let's see one is the ship-to-party(SHP) and the other one is the sold-to-party(SDP). So the fact table has two keys KeySHP and KeySDP. I can create one active relation to the Customer Dimension and one inactive one. Now I want to create to measures to be able to create a visual with: Sales Amount; Ship-to-Party, Sold-to-Party I assume I need to make two measure to be able to use Ship-to-Party and Sold-to-Party and I believe it should look like: Ship-to-Party = Calculate(Max(DimensionCustomer[Ship-to-Party]), USERELATIONSHIP(DimensionCustomer[KeySHP], FactSales[KeySHP]) Is it correct to use role playing dimensions in this way?

[amitchandak · Accepted solution]

@Kpham , USERELATIONSHIP is used for this purpose. Hope this one was inactive. As for active you can skip this.

The approach is correct. Use in measures only.

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...