Issue trying to block the 'between' slicer through a measure

[amaaiia]

The goal of what I want to achieve is that when I select the 'last30days' option in the slicer, the calendar gets locked, and when I select 'custom', it gets activated. I am trying to achieve this with the following measure, which is set to 1 if I select the 'custom' option and to 0 if I select the 'last30days' option.

 I have this measure in the calendar filters as shown in the following image. The problem is that regardless of the option I select, the calendar gets deactivated. 

This happens with the 'between' type slicer; with the rest, it performs the action correctly, but I need it to work with the 'between'.

[v-cgao-msft · Accepted solution]

Hi @amaaiia ,

By default, the interaction state between slicers is off. Please turn it on manually:

30days = 
VAR __min_date = MIN( 'Date'[Date] )
VAR __max_date = MAX( 'Date'[Date] )
VAR __today = TODAY ()
VAR __30_days_before = __today - 29
VAR __filter_tag =
    IF (
        ISBLANK ( SELECTEDVALUE ( CU_003_TRAZA_LAST30DAYS[tipo] ) )
            || SELECTEDVALUE ( CU_003_TRAZA_LAST30DAYS[tipo] ) = "custom",
        1,
        IF ( __min_date >= __30_days_before && __max_date <= __today, 1, 0 )
    )
RETURN
    __filter_tag

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum