Back to Roadmap
Level 2 — Working With Filters+75 XP
Lesson 2

2. The Supreme CALCULATE

The only DAX function capable of creating and modifying filter context.

The Concept

CALCULATE evaluates an expression in a modified filter context.
Example DAX:
Enterprise Revenue = 
CALCULATE(
    SUM(Sales[Revenue]),
    Customers[Segment] = "Enterprise"
)

CALCULATE takes an expression as its first argument and any number of filter arguments. The filters modify or overwrite the existing filter context.

Try It Yourself

Calculate total revenue specifically for the 'Consumer' segment.

fx
[fx]The Supreme CALCULATE=
Loading DAX Formula Studio...
Type [ for fields