Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count selected values in a slicer

Hi all ,   I'm using  TestSlicerCount = COUNTROWS(VALUES(FinalTable[Month])) , to count the number of selected values in a slicer with 12 values, works fine but when there are no selections it ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I managed to make it work , thank you amitchandak .

     

    I used this , 

    TestSlicerCount = IF(ISFILTERED(FinalTable[Month]), COUNTROWS(VALUES(FinalTable[Month])),0)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I managed to make it work , thank you amitchandak .

 

I used this , 

TestSlicerCount = IF(ISFILTERED(FinalTable[Month]), COUNTROWS(VALUES(FinalTable[Month])),0)
alyona22121995's avatar
alyona22121995
Regular Visitor
3 years ago

Is it possible to ignore some months for slicer count? so for example count all selected on slicer, except 9,10,11,12
thanks!