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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
