If condition to filter by date

[Datavizuserpbi]

Hello,

I want to filter the column Magasin in a slicer visual when the selected date is between range of date  with this:

if(max_<=date_max && max_>=date_min ,1,0)

The result is 0 while it's should be 1 for the top 3 of the year because it's take the lastdate of the year.

Condition	Year	Magasin
0	2021	ST MARC

Condition	Year	Month	Magasin
1	2021	01	ST MARC
1	2021	02	ST MARC
1	2021	03	ST MARC
0	2021	04	ST MARC

When i apply the filter at 1 on the slicer Magasin and i'm using the slicer year my value is filtered and i want even if i have only 3 months the result has to be 1 for the year .

To be clearer, if there is at least one month in which the condition is equal to 1, the condition must be equal to 1 for the whole year.

Thank you for your help

[lbendlin]

Use MAXX  over the monthly results.