Display warning message if the count of selected months from the date slicer is more than 3 months

[NKotak_Leecare]

Hi all,

I want to create a measure that counts the selected months from a date slicer and if it is more than three months, then display a warning message.

I have tried this measure: Multi_Selected_Months = CONCATENATEX ( VALUES ( financials[Month Name] ) , [Month Name] , ",")

but it is for displaying selected months.

Can anyone please suggest a solution for this?

Much thanks!!

[Ritaf1983 · Accepted solution]

Hi @NKotak_Leecare 
You can use this DAX formula for counting selected Months:

 counter = IF(ISFILTERED(dates[month]), COUNTROWS(VALUES('dates'[month])),0)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.