Unapply a Filter Using DAX
March 28, 2023 - by Bill Jelen
SUMIFS, you go through a data set, finding rows that match all of the criteria.
CALCULATE, you go through a data set, calculating values that match the filters in
CALCULATE. 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 the
CALCULATEfunction, but it also has to respect Month=Jan caused by the row label in D4 and Year=2016 caused by the slicer.