Impara CALCULATE and ALL | Data Modeling and DAX Fundamentals

Scorri per mostrare il menu

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

Tutto è chiaro?

Grazie per i tuoi commenti!

Sezione 3. Capitolo 6

Chieda ad AI

Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione

Sezione 3. Capitolo 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`?