Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

USERELATIONSHIP with TEXT

Hi,   I would like to retrieve a text with the CALCULATE ( xxx, USERELATIONSHIP (xxx) ) formula. I understand that USERELATIONSHIP must be used inside a CALCULATE function, but what I want to retr...
Need Help
Kpham's avatar
Kpham
Icon for Resolver I rankResolver I
4 years ago

I have the same question. And I only find examples where they use the date/time in role playing dimension

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?