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 retrieve is just text only without any calculations.

Does anyone knows how to get the text from a CALCULATE function?

 

 

Best regards,

Emily

 

 

 

Need Help

12 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Ashish,

       

      Here is an example.

       

      Master Table

      Column 1: TableID

      Column 2: POLCountryName

       

      Child Table

      Column 1: POLCountryName

      Column 2: Count_POLCountry

       

      I want to create a MEASURE to retrieve the POLCountryName from the ChildTable so that the POLCountryName can be displayed into a map (using MapBox plug-in) as a Tooltip.

      Since my data must be linked by USERELATIONSHIP function, I cannot simply drag & drop POLCountryName from the MotherTable into the tooltip of the map because it doesn't give me the correct result.

      In addition, the map tooltip only allow to display AGGREGRATE function (first / last / count distinct / count) and there is no option for "Don't summarize" as it doesn't appear in the right click option, so I tried to create a ChildTable and see whether I can use CALCULATE (xxx , USERELATIONSHIP (xxx) ) to retrieve the POLCountryName from the ChildTable.

       

      Is there any other ways that can help me to display the correct POLCountryName in the map in consideration of the USERELATIONSHIP?

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        Does this work?

        =CALCULATE(VALUES('Master Table'[PolCountryName]),USERELATIONSHIP('Child Table'[PolCountryName],'Master Table'[PolCountryName]))

  • Kpham's avatar
    Kpham
    Resolver 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?