O'Reilly logo

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Marco Russo, Alberto Ferrari

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required