topic Re: Measure to Combine Text Values in DAX Commands and Tips

Measure to Combine Text Values

Anonymous — Fri, 07 Mar 2025 21:15:32 GMT

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.

Re: Measure to Combine Text Values

Greg_Deckler — Fri, 07 Mar 2025 22:09:04 GMT

Anonymous

Measure = CONCATENATEX( DISTINCT('Table'[Thing]), [Thing], " and " )

Re: Measure to Combine Text Values

Anonymous — Sat, 08 Mar 2025 17:32:14 GMT

Brilliant! So glad I got close

Re: Measure to Combine Text Values

Anonymous — Tue, 11 Mar 2025 18:21:45 GMT

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