Forum Discussion

kfrancis's avatar
kfrancis
Regular Visitor
8 years ago
Solved

Ignore page level filter in Measure

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 ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

     

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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's avatar
    kfrancis
    Regular Visitor
    8 years ago

    Worked a treat, thank Jimmy