Aprende CALCULATE and ALL | Data Modeling and DAX Fundamentals

Desliza para mostrar el menú

CALCULATE is the most important function in DAX. It lets you run a calculation inside a modified filter context, which means you can write measures that ignore certain filters, apply new ones, or compare against a fixed benchmark regardless of what the report user has selected.

In this chapter you'll build several real measures using CALCULATE. By the end, you'll understand how to control filter context deliberately and have a Pct of Total Sales measure ready for your dashboard.

1. You write the measure: `Pct of Total Sales = DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Sales)))`. A user applies a `Region` slicer to filter the report to `West` only. What does the denominator in this measure return?

2. What is the correct syntax for `CALCULATE`?

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 3. Capítulo 6

Pregunte a AI

Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla

Sección 3. Capítulo 6

CALCULATE and ALL

1. You write the measure: Pct of Total Sales = DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Sales))). A user applies a Region slicer to filter the report to West only. What does the denominator in this measure return?

2. What is the correct syntax for CALCULATE?

1. You write the measure: `Pct of Total Sales = DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Sales)))`. A user applies a `Region` slicer to filter the report to `West` only. What does the denominator in this measure return?

2. What is the correct syntax for `CALCULATE`?