Lære CALCULATE and ALL | Data Modeling and DAX Fundamentals

Sveip for å vise menyen

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`?

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 6

Spør AI

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

Seksjon 3. Kapittel 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`?