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
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()