CALCULATE Function (DAX)

🎯Purpose

Evaluates an expression in an altered or overridden filter context. The cornerstone function of DAX.

Syntax

DAX

CALCULATE(<expression>, <filter1>, <filter2>, ...)

DAX

AnsweredCalls := CALCULATE(
    COUNTROWS(Fact_Calls),
    Fact_Calls[Answered (Y/N)] = "Y"
)