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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Share some data and show the expected result.

  • 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
      Icon for Super User rankSuper User
      7 years ago

      Hi,

      Does this work?

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Ashish,

         

        No, it didn't work and not able to display what I need.

        This formula only works at modelling level, but not at visual level.

        In addition, if I pull this new measure into the tooltip of MapBox, the tooltip still limits to the aggregate functions only (first / last / count distinct /count).

         

        Best regards,

        Emily