How to count Date Filter selected on Slicer

[MYDATASTORY]

Hi,

I have a date Slicer which has all the  Date column and I have formatted date to Month to be used on Slicer

I would like to have a measure for every time the user selects Month Slicer to count and add total so for this one will be 2  because the user has selected to Month on Month slicer. Thank you in advance
Date                    Month  (Formatted month from date column)

01/2/2020           February2020

3/4/1960             April1960

[v-eachen-msft · Accepted solution]

Hi @MYDATASTORY ,

You could use ALLSELECTED() to get the status of slicer. Here is the measure for your reference.

Measure =
IF (
    ISFILTERED ( 'Table'[Month] ),
    COUNTROWS ( ALLSELECTED ( 'Table'[Month] ) ),
    0
)

[mahoneypat]

Do you just want the count of months the user has selected?  If so, you can make this measure and put it in a card visual, replacing Table with your actual table name that has the Month column.

Months Selected = DISTINCTCOUNT(Table[Month])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat