ALL/REMOVEFILTERS not working when using certain filters

[benyhh]

As the title suggest, ALL/REMOVEFILTERS does not work when I apply certain filters. This problem occurs with my date table, which has columns including these.

Date	IsWorkday	RelativeDay	Week	Year
01.01.2023	No	-4	1	2023
02.01.2023	No	-3	1	2023
03.01.2023	Yes	-2	1	2023
04.01.2023	Yes	-1	1	2023

I need a measure that returns the first date in the filter context, ignoring the IsWorkday filter:

MinDate =
CALCULATE(
    MIN(Date[Date]),
    REMOVEFILTERS(Date[IsWorkday])
)

To test this, I make a table with Date[Week] and MinDate, using filters Date[Year]=2023 and Date[IsWorkday]=Yes. 

Week	MinDate
1	01.01.2023

The problem is that filtering on RelativeDay is very common in my organization, and when I do that, the REMOVEFILTERS does not work as intended anymore. The filters are now Date[Year]=2023, Date[IsWorkday]=Yes, and Date[RelativeDay]<0.

Week	MinDate
1	03.01.2023

I am using a direct query to a published dataset in my organization. Any help to figure out the problem is appreciated. Please let me know if you need additional information.

[amitchandak]

@benyhh , I tried, it worked

[benyhh]

Yes, it should work, and this is why I need help to figure out what the problem is.

The data I provided was just a sample and the original model is bigger and more complex.

Below I show the Date, IsWorkday, and RelativeDay in a table. Then I show the measure ignoring the "IsWorkday" slicer and returning 02.01.2023. When I apply RelativeDay less than -3, the measure does not ignore the slicer anymore.

All the columns used in the tables and filters are in the same date table.