Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NKotak_Leecare
Helper III
Helper III

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

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!!

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

 counter = IF(ISFILTERED(dates[month]), COUNTROWS(VALUES('dates'[month])),0)
Ritaf1983_0-1683080159801.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

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

 counter = IF(ISFILTERED(dates[month]), COUNTROWS(VALUES('dates'[month])),0)
Ritaf1983_0-1683080159801.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.