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!
Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.