11. Using DAX for Date Magic
In This Chapter
Be honest. Did you really read Chapter 10, “Using DAX for Aggregate Functions,” or did you skip it?
If you skipped it, let me offer a recap for you:
=CALCULATE(Sum(Sls[Sales]), Filter 1, Filter 2, ...)
This calculated field will calculate the total sales for all rows that match the filters specified. If one of the filters specified in the
CALCULATE function is for a dimension already in the pivot table, the filter in
CALCULATE will override the filter in the pivot table.
Most of the time intelligence functions are designed to be used as the filter in ...