Measure to Combine Text Values

[Anonymous]

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]

Brilliant! So glad I got close

[Greg_Deckler · Accepted solution]

@Anonymous 

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

[Anonymous]

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