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,

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    So you mean that you get the correct answer with my formula when you drag my formula to a Table visual, but not when you drag it to the tool tip section.  Am i correct?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes you are correct.

      Any workaround solutions to fix this problem?

      Thanks!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        That is very strange.  Sorry i do not know why that is happening.