CALCULATE Function Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Create Model Calculations with DAX

What you'll be asked

  1. What is the primary purpose of the CALCULATE function in DAX?
  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. Which function is best used within CALCULATE to remove all filters from a specific table or column?
  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. Consider the measure: CALCULATE(SUM(Sales[Amount]), KEEPFILTERS(Sales[Region] = 'North')). How does KEEPFILTERS change the standard behavior of CALCULATE?

Answers and explanations come after you submit.