Unapply a Filter Using DAX
March 28, 2023 - by Bill Jelen

With SUMIFS
, you go through a data set, finding rows that match all of the criteria.
- With
CALCULATE
, you go through a data set, calculating values that match the filters inCALCULATE
. BUT...you also have an external outside force that is forcing other filters to be applied. Those filters might be coming from the slicers or even from the row and column labels. When Power Pivot goes about calculating cell F4 in the figure above, it has to respect the weekday=Saturday in theCALCULATE
function, but it also has to respect Month=Jan caused by the row label in D4 and Year=2016 caused by the slicer.