Card for Slicer Selection

[roncruiser]

Hi,
I'd like to see within a card a comment based on selection of the slicer.
I'm not sure how go about this.

This is the slicer:

If "Selected All" or none selected then "All".
If all 0-7 in green selected then "Sub".
If only 220 selected then "High".
If there are random selections then "Multiple".

This will be for a title of a chart.  I'm working with selectedvalue but with no success so far.  Still going at it.

[roncruiser]

I likely was not clear with the card expectations.
@amitchandak 
@Anonymous 

Here's a better example:

Slicer settings:

 if none selected.  Card reads "none".

 if all selected. Card reads "All".

 if all selected as shown. Meaning all of 0-1-2-3-4-5-6-7 are selected at the same time. Card reads "Sub".

 if only "220" is selected as shown. Card reads "High".

Thanks for the attemped solutions, but none of them met the criteria or did something entirely different than intended.

I tried to play around and modify the solutions but still could not get them to work.
Still seeking help please.

[roncruiser]

@Anonymous 

I commented out the line for "Multiple".  I still do not know what [ct] mean.  Until that is clear, I can leave that out.
As you can see, even when nothing is selected "All" does show up in the card.
Along the same lines, selecting 0-7, "Sub" does not show either on the card.

I'll play with your expression to see if I can get it to go.

Thanks for the response.
Any further help is appreciated!

[Anonymous · Accepted solution]

Hi,

this should do the trick:

Switch(

    TRUE(),

    DISTINCTCOUNT('Table'[column]) = CALCULATE(countrows('Table'), ALL('Table')), "All",

    DISTINCTCOUNT('Table'[column])>1 ||  DISTINCTCOUNT('Table'[ct]) > CALCULATE(countrows('Table'), ALL('Table')) -1, "Multiple",

    VALUE(Selectedvalue('Table'[column]))*1 <= 7, "Sub",

    VALUE(Selectedvalue('Table'[column]))*1  =220, "High"

)

Regards,

Max

[roncruiser]

Thank you Anonymous Max.  I revisted this and was able to implement your measure.

[roncruiser]

@Anonymous 

Hi Max,

I do not know what [ct] means with respect to the expression.  I do not have a column "ct" in my table.
Should I use an use an explicit measure to get count?  Does ct = count?

Thanks.
Ron

[amitchandak]

@roncruiser ,

Switch(

isblank( Selectedvalue(Table[Column])) , "All",

Selectedvalue(Table[Column]) *1 <=7, "Sub"

Selectedvalue(Table[Column]) *1 =220, "High"

//add other conditions

)

[roncruiser]

@amitchandak 

Thank You for the reply.

Maybe there is somethings I am missing as it is not working for me.  I created the measure and 
dropped it into a card and choose the slicer settings but get the following....

Not sure what I am doing wrong.