Create a filter with condition in selection with an alert

[amirabedhiafi]

I have a filter containing the Year and the Month like below :

I want to make a rule to select only one year and two months in that year. Example : I select 2020 and then April and May.

Can I also add a message alert ? when selecting only one year and one month, a message appears "You should select two months"

[v-xiaotang · Accepted solution]

Hi @amirabedhiafi 

Thanks for reaching out to us.

You can try this,

1. insert a text box, and create the measure, 

Measure = 
    var _selectedYears=IF(ISFILTERED('Table'[Date].[Year]),CALCULATE(DISTINCTCOUNT('Table'[Date].[Year]),ALLSELECTED('Table')))
    var _selectedMonths=IF(ISFILTERED('Table'[Date].[Year]),CALCULATE(DISTINCTCOUNT('Table'[Date].[Month]),ALLSELECTED('Table')))  
return IF(_selectedYears<>1||_selectedMonths<>2,"You should select two months")

2. then put the measure into the text box

result

Best Regards,

Community Support Team _Tang

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

[VahidDM]

Hi @amirabedhiafi 

Create a measure with the below codes and add that to the Text Box:

Text Alert =
VAR _DC =
    DISTINCTCOUNT ( [Month] )
RETURN
    IF ( _DC <> 2, "You should select two months", BLANK () )

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

Appreciate your Kudos!!