thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

CALCULATE Function

The DAX function that evaluates an expression in a modified filter context, adding, replacing or removing filters.

Definition

CALCULATE(expression, filter1, ...) applies Boolean or table filters, overriding existing filters on the same columns, and performs context transition when used in row context. Modifiers include ALL, REMOVEFILTERS, KEEPFILTERS, USERELATIONSHIP and CROSSFILTER.

Example

West Sales = CALCULATE([Total Sales], Region[Name] = "West")

Exam tip

Boolean filters in CALCULATE replace existing filters on that column; wrap with KEEPFILTERS to intersect instead.

Related terms