CALCULATE Function Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Create Model Calculations with DAX

CALCULATE Function Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    What is the primary purpose of the CALCULATE function in DAX?

  2. 2

    If you use CALCULATE to filter a measure by 'Color' = 'Red' and the current report filter is also set to 'Color' = 'Blue', what will be the result?

  3. 3

    Which function is best used within CALCULATE to remove all filters from a specific table or column?

  4. 4

    What happens when you use multiple filter arguments in a single CALCULATE function (e.g., CALCULATE([Sales], 'Date'[Year]=2023, 'Product'[Category]='Electronics'))?

  5. 5

    Consider the measure: CALCULATE(SUM(Sales[Amount]), KEEPFILTERS(Sales[Region] = 'North')). How does KEEPFILTERS change the standard behavior of CALCULATE?