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
roncruiser's avatar
roncruiser
Icon for Post Patron rankPost Patron
3 years ago

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!