DAX Introduction Quiz

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

Quiz covering Create Model Calculations with DAX

What you'll be asked

  1. Which of the following describes the primary difference between a Calculated Column and a Measure in DAX?
  2. If you want to calculate the total sales for the 'Red' color category regardless of the current slicer selection, which function should you use?
  3. Which DAX function is used to create a relationship between two tables that do not have a defined model relationship for the duration of a calculation?
  4. What is the result of the DAX expression: DIVIDE(SUM(Sales[Amount]), 0, 0)?
  5. When using the CALCULATE function, what happens if you provide multiple filter arguments?

Answers and explanations come after you submit.