🔥 DAX Interview Questions 🔥

Q1 : What is the difference between a Calculated Column and a Measure?

✅ Answer:

A Calculated Column is computed row by row and stored in the data model.

A Measure is calculated dynamically at query time based on the current filter context and is not stored.

Q2 : What is Filter Context in DAX?

✅ Answer:

Filter Context is the set of filters applied to a calculation through visuals, slicers, filters, or DAX expressions. It determines which data is included in the calculation.

Q3 : What is the purpose of the CALCULATE() function?

✅ Answer:

CALCULATE() modifies the filter context before evaluating an expression. It is one of the most powerful and frequently used functions in DAX.

Q4 : What is the difference between ALL() and REMOVEFILTERS()?

✅ Answer:

Both functions remove filters from columns or tables.
REMOVEFILTERS() is generally preferred for readability, while ALL() can also return a table and is often used in advanced DAX calculations.

React ♥️ for more interview questions 🔥