Ignore page/report date filter in measure

[Matti]

Hello,

I am building a report in which a report filter is needed for almost all visualizations and tables throughout, the filter is a 'year' filter related to the calender table. 

However, one matrix table needs to make use of user defined date slicers and ignore the report level 'year' filter, so that the user can see the value for the next 12 month starting from the date selected - the user defined slicers are not connected to the calendar table or any other data. Below is a picture of the outcome I would ideally end up with, but when the report filter is active it naturally intervenes with the measure build for the purpose.

In order to ignore the report-level filter I've experimented with the ALL-function, but the final measure returns nothing. Below is the measures I've tried using. Note how Fdate and Ldate are defined by the slicers shown above.

IF(MINX(All(DIM_Time);Dim_Time[THEDATE])>Dim_EndTime[Fdate1];
BLANK();
IF(MINX(All(DIM_Time);Dim_Time[THEDATE])<Dim_EndTime[Ldate1];
BLANK();
1))

and 

CALCULATE(1;
FILTER(
all(DIM_Time[THEDATE]);
and(DIM_Time[THEDATE]>[Fdate1];
DIM_Time[THEDATE]<[Ldate1])))

I might have overcomplicated the description, but all I want is to ignore the report date filter and apply my own user defined date filter from some slicers.

[Greg_Deckler]

Use ALLEXCEPT instead of all, this will allow you to keep some filters but exclude others.