Forum Discussion

roncruiser's avatar
roncruiser
Icon for Post Patron rankPost Patron
3 years ago
Solved

Card for Slicer Selection

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-...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

roncruiser ,

Switch(

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

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

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

//add other conditions

)

roncruiser's avatar
roncruiser
Icon for Post Patron rankPost Patron
3 years ago

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.