✏️ Explanatory Question

What does CALCULATE() do?

👁 0 Views

📘 Detailed Answer

🟢 Easy

💡

Answer with Explanation

CALCULATE() is one of the most powerful DAX functions.

It modifies the filter context of an expression.

Total Sales East =
CALCULATE(
    SUM(Sales[Amount]),
    Sales[Region] = "East"
)

CALCULATE is considered the heart of advanced DAX development.