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

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

        Hi,

        Replace VALUES() with MAX()