Forum Discussion
Measure to Combine Text Values
I am trying to create a measure (I think) to combine text values to use in a map legend. Country Thing Country A Dogs Country A Cats Country B Dogs Country C Dogs C...
Anonymous
Measure = CONCATENATEX( DISTINCT('Table'[Thing]), [Thing], " and " )
Greg_Deckler
Community Champion
Community ChampionAnonymous
Measure = CONCATENATEX( DISTINCT('Table'[Thing]), [Thing], " and " )I'm realizing that I can't use a measure in a map legend.
Is there a way to do this -not- as a measure? I was trying to to do various levels filtered tables to reference the measure to be able to use it, but I can't get around it calculating this before I get my data filtered, so its showing all possible concatenations that exist in the data set - not what's actually in the data being represented in the map