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
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi I have a similar problem with using USERRELATIONSHIP with text columns. Trying to match online comments with locations, and tehre is already a connection with Date Table. So I use relationship dax to be able to use location slicer. Here is the Dax but it gives an error of multiple values was supllied where a single value was expected. Could you help me on that please, thanks

        Comments Locations = CALCULATE(VALUES('Reviews'[Comment]),USERELATIONSHIP(Location[Storefront], 'Reviews'[Store]))