Quiz on Common DAX Functions in Power BI

Which DAX function returns the total of a column’s numeric values?

What will SUM return if the column contains NULL values?

Which DAX function returns the arithmetic mean of a column?

If you want to count all rows, including blanks, which function should you use?

Which function counts only numeric values and ignores blanks or text?

What does COUNTA count?

Which function counts blank cells in a column?

 If you want the average of an expression evaluated row by row, which function is used?

Which function is best for counting unique values?

What will SUM return if applied on a text column?

If you need to calculate the sum for each group, which function can be used with grouping co

Which function would return 0 if no values exist instead of blank?

Which is more efficient for counting rows in a large table?

Which function is best for calculating averages based on conditions?

Which of these functions can operate on an expression instead of a direct column reference?