Power BI 778 DAX Formulas and Calculations

Question 1

What does the DAX function CALCULATE do?

Accepted Answer

Evaluates an expression in a modified filter context

Answer

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

Question 2

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

Accepted Answer

CALCULATE(SUM(), ALL())

Answer

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

Question 3

What is the difference between SUM and SUMX in DAX?

Accepted Answer

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

Answer

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

Question 4

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

Accepted Answer

COUNTROWS

Answer

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

Question 5

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

Accepted Answer

Removes all filters from the specified table or columns

Answer

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

Power BI 778 Practice Test