DAX Formulas and Calculations Flashcards

What does the DAX function CALCULATE do?

Answer: Evaluates an expression in a modified filter context

CALCULATE evaluates a DAX expression after applying the specified filter modifications to the current filter context.

Which DAX function returns the total of all values in a column, ignoring any filters?

Answer: CALCULATE(SUM(), ALL())

Wrapping SUM with CALCULATE and ALL() removes all filters, returning the grand total regardless of current context.

What is the difference between SUM and SUMX in DAX?

Answer: SUM works on columns; SUMX iterates a table row by row

SUM aggregates a single column directly, while SUMX iterates each row of a table and evaluates an expression per row.

Which DAX function counts the number of rows in a table?

Answer: COUNTROWS

COUNTROWS returns the number of rows in a specified table or table expression.

What does the ALL() function do when used inside CALCULATE?

Answer: Removes all filters from the specified table or columns

ALL() removes filters from the specified table or columns, allowing calculations to ignore slicers and report filters.

Which DAX time intelligence function calculates year-to-date totals?

Answer: TOTALYTD

TOTALYTD evaluates an expression from the beginning of the year up to the last date in the current filter context.