DAX help on category

[Lauraeire_81]

Hi 

I am looking to display the Countries listed depending on what food items are selected in a slicer (where multiple options can be selected).

Say 'Hot Dogs', 'Corn dogs' and 'Stew' are selected, I want a measure to say something like this:

'Corn Dogs' and 'Hot dogs' found in 'America'. Count of 2. 

'Stew' is found in Ireland. Count of 1.

Is there any way to search on a table like this and display the items in a similar format?

Thanks in advance,

Laura

See table 'CountryFood' below. 

Countries	Food
America	Hot dogs
America	Corn dogs
America	Bigmacs
Ireland	Stew
Ireland	Cabbage and bacon

[AilleryO]

Hi,

We need more details to really help you but basically, if you want to get the selectedvalue :

Get Category List (selected ones) =
VAR LstCat = DISTINCT( Products[Category] )
VAR NbCat = COUNTROWS( LstCat )
RETURN
SWITCH( TRUE() ,
 NOT ISFILTERED( Products[Category] ) , "All cat displayed" ,
 NbCat > 10    , "Too many cat selected (" & NbCat & " categories selected)" ,
 ISFILTERED( Products[Category] ) ,  CONCATENATEX( LstCat , Products[Category] , ", ")   )

In this formula, I test the number of category selected, not to display the result if there are too many (more than 10). So you can adapt that part for the count you required.

Let us know if you need more details

[Lauraeire_81]

AilleryO Thank you - this works.

Would it be possible to add a value if the 'Select all' value in the slicer was selected? I have 9 values and sometimes I would just want to select all of them.  Thank you.