topic Re: List of Slicer values with optional text value in DAX Commands and Tips

List of Slicer values with optional text value

Anonymous — Mon, 26 Dec 2022 11:38:56 GMT

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.

Re: List of Slicer values with optional text value

amitchandak — Mon, 26 Dec 2022 12:28:53 GMT

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

)

Re: List of Slicer values with optional text value

Anonymous — Mon, 26 Dec 2022 12:56:34 GMT

hi amitchandak ,

you are indeed a Super User,

all works, increadible, thanks a lot!