Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

An iterator function always includes at least two arguments. What are they?

Column and expression

Table and expression

Measure and expression

2.

Which statement about DAX iterator functions is true?

When used to add values of the same column, the SUMX function performs better than the SUM function.

Iterator functions iterate over tables and evaluate an expression for each table row.

Iterator functions iterate over expressions and evaluate tables for each row.

3.

You're developing a Power BI Desktop model. You need to create a measure formula by using the RANKX DAX function to rank students by their test results. The lowest rank should be assigned to the highest test result. Also, if multiple students achieve the same rank, the next student rank should follow on from the tied rank number. Which order and ties arguments should you pass to the RANKX function?

Order Ascending | Ties Skip

Order Ascending | Ties Dense

Order Descending | Ties Dense

You must answer all questions before checking your work.