Ignore page level filter in Measure

[kfrancis]

I have tried all the solutions from other posts but must be missing something because cannot get this to work.

I have a measure to total planned production quantity for the week but I add a page level filter to filter by shift date on the page for other visuals it is changing this measures total. I have tried ignoring the filter with the ALL statement but this does not work. Please can someone help?

CALCULATE(SUM(FactSales[FactoryFrames]),ALL(DimShiftDate),
    FILTER(DimProductionDateFS,DimProductionDateFS[Date] > TODAY() - WEEKDAY(TODAY())),
    FILTER(DimProductionDateFS,DimProductionDateFS[Date] < TODAY() + 7 -WEEKDAY(TODAY())))

[v-yuta-msft · Accepted solution]

Hi kfrancis,

Modify your dax like this and check if it can work.

Result = CALCULATE(SUM(FactSales[FactoryFrames]),ALL(DimShiftDate),
    FILTER(ALL(DimProductionDateFS),DimProductionDateFS[Date] > TODAY() - WEEKDAY(TODAY())),
    FILTER(ALL(DimProductionDateFS),DimProductionDateFS[Date] < TODAY() + 7 -WEEKDAY(TODAY())))

Regards,

Jimmy Tao

[kfrancis]

Worked a treat, thank Jimmy

[dannn777]

try turning off interactions by clicking on the visuals that are affecting the slicer, then going to format > edit interactions, then click the none icon on the slicer

[kfrancis]

Thanks for reply Dann, sorry I am new and got the description wrong, the issue I am having is with a page level filter not a slicer filter (updated post to say this). Is there a way for a measure to ignore page level filters?

[parry2k]

which table is used for page level filter DimShiftDate or other table?

[kfrancis]

The DimShiftDate table.