© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. BoxUp and Running with DAX for Power BI https://doi.org/10.1007/978-1-4842-8188-8_6

6. The CALCULATE Function

Alison Box1  
Billingshurst, West Sussex, UK

CALCULATE is the most important function in DAX. Quite a sweeping statement you might think but as soon as you get to grips with CALCULATE, you’ll quickly realize that there won’t be many expressions you author in DAX where this function won’t be required, even though you might think we’ve done pretty well up to now. In this chapter, you will learn how to construct expressions using CALCULATE which you will find relatively straightforward. It’s understanding when and why you must use CALCULATE, and ...

Get Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users 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.