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

Sums values in a column

Answer

Counts rows in a table

Answer

Returns the first value in a column

Question 2

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

Accepted Answer

CALCULATE(SUM(), ALL())

Answer

SUM

Answer

SUMX

Answer

TOTALSUM

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 is faster than SUMX

Answer

SUMX only works with text columns

Answer

SUM supports multiple columns; SUMX supports one

Question 4

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

Accepted Answer

COUNTROWS

Answer

COUNT

Answer

COUNTA

Answer

COUNTBLANK

Question 5

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

Accepted Answer

Removes all filters from the specified table or columns

Answer

Applies all existing filters

Answer

Returns all values from a column as a list

Answer

Adds new filters to the context

Question 6

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

Accepted Answer

TOTALYTD

Answer

DATESMTD

Answer

DATESQTD

Answer

SAMEPERIODLASTYEAR