Chapter 8. Understanding CALCULATE

In this chapter, we continue to explore the power of the DAX language with a detailed explanation of a single function: CALCULATE. It might seem strange to dedicate a full chapter to a single function, but this is necessary because of the richness and side effects of this particular one. CALCULATE is by far the most important, useful, and complex function of the DAX language. In reality, the function is easy: it performs only a few tasks, but the number of scenarios where CALCULATE is necessary and the complexity of the formulas that can be written with CALCULATE make a full chapter absolutely justified.

Like the previous chapter, this chapter is about a complex subject. We strongly suggest to read it once, get ...

Get Microsoft Excel 2013: Building Data Models with PowerPivot now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.