List of Slicer values with optional text value

[Anonymous]

Hi all!

please help with the following,

I have a Geo slicer with list of regions, for the sake of this example let's use continets:

• Asia
• Africa
• Europe
• North America
• South America
• Australia/Oceania
• Antarctica

I created a Dynamic Text Box which returns selected values from a slicer, 
e.g.
if Europe is selected it returns => Europe ,

if Asia and Europe is selected it returns => Asia and Europe,

if 3 or more continets are selected it returns => Asia and Europe, etc.

if all continets are selected (or none is selected) it returns => All.

the only thing I can't figure out is how to return "all but one" when one continet is deselected
e.g. => "all but Europe" when all continents except Europe is selected or other scenarios.

[amitchandak · Accepted solution]

@Anonymous ,  Try a measure like 

Add other conditions

Switch( True() ,

countx(all(Table[Regions]), [Regions]) -1= countx(allselected(Table[Regions]), [Regions]) , "all but" & maxx(except(all(Table[Regions]), allselected(Table[Regions])), [Region]) ,

// add other conditions

)

[Anonymous]

hi @amitchandak ,

you are indeed a Super User, 

all works, increadible, thanks a lot!