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
Anonymous's avatar
Anonymous
Not applicable
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 

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