Forum Discussion
USERELATIONSHIP with TEXT
Hi Ashish,
Here is an example.
Master Table
Column 1: TableID
Column 2: POLCountryName
Child Table
Column 1: POLCountryName
Column 2: Count_POLCountry
I want to create a MEASURE to retrieve the POLCountryName from the ChildTable so that the POLCountryName can be displayed into a map (using MapBox plug-in) as a Tooltip.
Since my data must be linked by USERELATIONSHIP function, I cannot simply drag & drop POLCountryName from the MotherTable into the tooltip of the map because it doesn't give me the correct result.
In addition, the map tooltip only allow to display AGGREGRATE function (first / last / count distinct / count) and there is no option for "Don't summarize" as it doesn't appear in the right click option, so I tried to create a ChildTable and see whether I can use CALCULATE (xxx , USERELATIONSHIP (xxx) ) to retrieve the POLCountryName from the ChildTable.
Is there any other ways that can help me to display the correct POLCountryName in the map in consideration of the USERELATIONSHIP?
Hi,
Does this work?
=CALCULATE(VALUES('Master Table'[PolCountryName]),USERELATIONSHIP('Child Table'[PolCountryName],'Master Table'[PolCountryName]))
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
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?
Yes you are correct.
Any workaround solutions to fix this problem?
Thanks!
Hi Ashish, this solved my problem similar to OP's thank you
You are welcome.
