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