Вивчайте CALCULATE and ALL | Data Modeling and DAX Fundamentals

Свайпніть щоб показати меню

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

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 3. Розділ 6

Запитати АІ

Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат

Секція 3. Розділ 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`?