🎯 Interview Questions

1️⃣ What does CALCULATE() do?

It evaluates an expression after modifying the filter context.

2️⃣ What is the difference between ALL() and REMOVEFILTERS()?

Both can remove filters, but REMOVEFILTERS() clearly communicates that the intention is to remove filters.

3️⃣ What is ALLSELECTED() used for?

It helps calculate results based on the user's selected context while ignoring certain visual-level filters.

4️⃣ What is KEEPFILTERS()?

It preserves existing filters when applying additional filters.

5️⃣ What is context transition?

The conversion of row context into filter context, typically triggered by CALCULATE().

🧪 PRACTICE

Create these measures:

Total Sales

West Sales

Total Sales All Regions

Sales % of Total

Sales % of Selected Regions

Then add:

✔ Region slicer

✔ Category slicer

✔ Sales by Region chart

Change the slicers and observe how each measure behaves.

That observation is one of the best ways to understand DAX filter context.

💡 Key lesson:

Don't memorize CALCULATE().

Understand what filters exist, which filters you want to change, and what result you expect.

Double Tap ❤️ For More