Question 1

What does the AVERAGE function in DAX calculate?

Accepted Answer

The average of a set of numbers

Answer

The sum of a set of numbers

Answer

The mode of a set of numbers

Answer

The median of a set of numbers

Question 2

Which function includes text and logical values in its calculation?

Accepted Answer

AVERAGEA

Answer

AVERAGE

Answer

AVERAGEX

Answer

MEDIAN

Question 3

What is a key difference between AVERAGE and AVERAGEX functions?

Accepted Answer

AVERAGEX calculates the average of an expression over a table

Answer

AVERAGE includes text values

Answer

AVERAGEA calculates over a table

Answer

AVERAGEX calculates the sum

Question 4

When using AVERAGEA, what happens to text values in the data set?

Accepted Answer

They are counted as zero

Answer

They are ignored

Answer

They cause an error

Answer

They are converted to numbers

Question 5

Which DAX function would you use to calculate the average sales amount per transaction?

Accepted Answer

AVERAGEX

Answer

AVERAGEA

Answer

SUMX

Answer

AVERAGE

Question 6

What type of data does the AVERAGE function ignore?

Accepted Answer

Text and logical values

Answer

Errors

Answer

All values

Answer

Numerical values

Question 7

In the context of Power BI DAX, what does AVERAGEX require that AVERAGE does not?

Accepted Answer

An expression and a table

Answer

A numerical threshold

Answer

A logical test

Answer

A single column of values

Question 8

For a column containing "TRUE", "FALSE", and numbers, which function will calculate the average correctly?

Accepted Answer

AVERAGEA

Answer

SUM

Answer

AVERAGE

Answer

AVERAGEX

Question 9

What is the result of AVERAGEA for a column with values 1, "A", 3?

Accepted Answer

1.333

Answer

1

Answer

4

Answer

2

Question 10

Which function would be most appropriate for calculating the average of complex expressions in a table?

Accepted Answer

AVERAGEX

Answer

AVERAGEA

Answer

AVERAGE

Answer

MINX

Related quizzes

Related quizzes