DAX Formulas and Functions Flashcards

What does the CALCULATE function do in DAX?

Answer: Evaluates an expression in a modified filter context

CALCULATE evaluates a DAX expression while applying one or more filters to modify the current filter context.

Which DAX function returns the sum of a column?

Answer: SUM

SUM takes a single column argument and returns the sum of all values in that column within the current filter context.

What is the difference between ALL and ALLEXCEPT in DAX?

Answer: ALL removes filters from all columns; ALLEXCEPT removes filters from all columns except specified ones

ALL removes all filters from a table or columns, while ALLEXCEPT removes filters from all columns except those listed.

What does the RELATED function do in DAX?

Answer: Returns a value from a related table following the many-to-one relationship

RELATED traverses a many-to-one relationship to retrieve a value from a column in a related table for the current row context.

Which DAX function calculates year-to-date totals?

Answer: TOTALYTD

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

What is the purpose of the DIVIDE function in DAX?

Answer: To safely divide two numbers and return an alternate result if the denominator is zero

DIVIDE safely handles division by zero by returning an optional alternate result (default blank) instead of an error.