Oppiskele CALCULATE and ALL | Data Modeling and DAX Fundamentals

Pyyhkäise näyttääksesi valikon

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

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 6

Kysy tekoälyä

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Osio 3. Luku 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`?