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

DavidUK0's avatar
DavidUK0
Frequent Visitor
3 years ago

Hi Ashish, this solved my problem similar to OP's thank you

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

    You are welcome.