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 |
| Country C | Cats |
| Country C | Cats |
And the result I want is
Country A : Dogs and Cats
Country B : Dogs
Country C: Dogs and Cats
Without some kind of measure I just end up with one thing, and if I use something like CONCATENATE X I end up with things listed way too many times, I just want one of each thing that occurs.
Anonymous
Measure = CONCATENATEX( DISTINCT('Table'[Thing]), [Thing], " and " )
3 Replies
Anonymous
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