Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
Measure = CONCATENATEX( DISTINCT('Table'[Thing]), [Thing], " and " )
Brilliant! So glad I got close
Measure = CONCATENATEX( DISTINCT('Table'[Thing]), [Thing], " and " )