ALLEXCEPT measure, but I want the Visual to stay filtered

[Thomas_Daubert]

Hello All, 

My question is probably answered somewhere but I can't find it. 

I created a measure like this: 

CountFailureInThePast10Weeks = 
CALCULATE(
    [Count Tasks Executions],
    ALLEXCEPT( TASK_HISTORY_VW, TASK_HISTORY_VW[STATE], TASKS_VW[NAME], TASKS_VW[SCHEMA_NAME] ,Datum[Past10Weeks], TASK_HISTORY_VW[DATABASE_NAME])
)

The goal is to have the number of failures in the past 10 weeks for a task. 

But I want to keep this number not filtered in a Visual filtered by date. 

So, without the measure in the visual, i get 5 lines, the 5 failure of the last 7 days (this is a filter in the visual). And when I add the measure that ignore the date filter, it add lines. 

I need, the measure calculated on 10 weeks history in a visual with only the tasks from last week. 

How I can achieve that ?

Thanks 😄 

[Thomas_Daubert]

Unfortunatly it doesn't works.

Initial state, my vis is filtered on Pastweek = true : 

After including the measure 

My goal is to keep image 1 with value from measure on image 2

[bhanu_gautam]

@Thomas_Daubert ,You can achieve this by using the REMOVEFILTERS function to remove the date filter context from the calculation

CountFailureInThePast10Weeks =
CALCULATE(
[Count Tasks Executions],
ALLEXCEPT(TASK_HISTORY_VW, TASK_HISTORY_VW[STATE], TASKS_VW[NAME], TASKS_VW[SCHEMA_NAME], TASK_HISTORY_VW[DATABASE_NAME]),
REMOVEFILTERS(Datum[Past10Weeks])
)