Chapter 5. Understanding CALCULATE and CALCULATETABLE
In this chapter we continue our journey in discovering the power of the DAX language with a detailed explanation of a single function: CALCULATE. In reality, the same considerations are valid also for CALCULATETABLE, which evaluates and returns a table instead of a scalar value. For simplicity, we will refer to CALCULATE in the examples, but remember that CALCULATETABLE has the same behavior.
It might seem strange to dedicate a full chapter to a single function, but this is essential because of its richness and side effects. CALCULATE is by far the most important, useful, and complex function of the DAX language. In reality, the function itself is an easy one. It only performs a few tasks, ...
Get The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI 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.
