DAX Context Quiz

Using context in your DAX calculations enables you to perform dynamic analysis, in which the results of a formula can change depending on the filter or slicer used.

Understanding context and using it effectively are key to building high-performing formulas.

Test your knowledge in the use of context in DAX when you take this online quiz. 

Read the following questions carefully and find the correct answer from the options provided. There’s no time limit to answer each question so take all the time you need, and then select the one you believe is correct. Some questions are more difficult and will naturally take longer to answer.

Remember: don’t cheat yourself!

The following definition is for which function:

Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
Which DAX function returns no value and only enables the indicated relationship for the duration of the calculation?
Which function returns a table that represents a subset of another table or expression?
Which DAX function returns all the rows in a table, or all the values in a column, ignoring any filters that may have been applied?
What is the correct definition of the ALL function?
CALCULATE transforms any existing filter context into an equivalent row context
Which DAX function evaluates a table expression in a context modified by the given filters?
What is special or unique about the CALCULATE and CALCULATETABLE functions?
Power BI DAX context style is…….
DISTINCT is a function that returns the list of unique values that are visible in the current cell, without returning the blank row for unmatched values. When there is no filters applied to which other function does behaviour of DISTINCT corresponds?
DAX Context Quiz
You got {{userScore}} out of {{maxScore}} correct

Return to DAX Quizzes