Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Separate CONCATENATEX

Good evening everyone,

I have created a custom tooltip that contains a button that contains a name. 

But if the name has multiple Land ID and YOP, the tooltip shows all the Land ID and YOP, not a single focused name

What I want is that when I specify the value of, for example LandID 10303011 and YOP 2005, the only value in the tooltip that showed is the only intended name value, not the entire value from the highest hierarchy. 

 My DAX code is:

Selected LandIDName = CALCULATE(CONCATENATEX(VALUES(DimLandID[LandID]),DimLandID[LandID],","))
Selected YOP = CALCULATE(CONCATENATEX(VALUES(DimLandID[YOP]),DimLandID[YOP],","))
I have tried with SELECTED Value, but the one that showed on the tooltip is string ALL
This is my SELECTED Value DAX:
Selected LandID = SELECTEDVALUE(DimLandID[LandID],"All")

How to get one single specific highlight value on the tooltip

Thank you very much

3 Replies