Exam Summary
0 of 20 Questions completed
Questions:
Information
You have already completed the exam before. Hence you can not start it again.
Exam is loading…
You must sign in or sign up to start the exam.
You must first complete the following:
Results
Results
0 of 20 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- 1: Understanding DAX Context 0%
- 2: Core Analytical Measures 0%
- 3: Time Intelligence Calculations 0%
- 4: Advanced Context Manipulation 0%
- 5: Ranking, Segmentation & KPI Scoring 0%
- 6: Advanced DAX Techniques 0%
- 7: Building Analytical KPIs 0%
- 8: DAX Documentation Template 0%
- 9: Performance Optimization 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
-
Question 1 of 20
1. Question
CorrectIncorrectHint
Measures respond to the filters applied by visuals.
-
Question 2 of 20
2. Question
CorrectIncorrectHint
This happens when a row context needs to behave like a filter context, usually involving CALCULATE.
-
Question 3 of 20
3. Question
CorrectIncorrectHint
You need to SUM the SalesAmount column from the FactSales table.
-
Question 4 of 20
4. Question
CorrectIncorrectHint
Which DAX function is specifically designed to handle division safely?
-
Question 5 of 20
5. Question
CorrectIncorrectHint
Look for the DAX function name that literally means “Total Year-To-Date”.
-
Question 6 of 20
6. Question
CorrectIncorrectHint
You want the value from the “Same Period” in the “Last Year”.
-
Question 7 of 20
7. Question
CorrectIncorrectHint
Remember the percentage change formula: (New – Old) / Old. Use the safe division function.
-
Question 8 of 20
8. Question
CorrectIncorrectHint
Which function lets you define a period based on a start/end date or an interval relative to an end date?
-
Question 9 of 20
9. Question
CorrectIncorrectHint
CALCULATE takes the measure, then the filter(s) you want to apply.
-
Question 10 of 20
10. Question
CorrectIncorrectHint
Divide the current sales by the sales for ALL regions. How do you remove the region filter in DAX?
-
Question 11 of 20
11. Question
CorrectIncorrectHint
CALCULATE needs a filter. FILTER function returns a table based on a condition applied row-by-row.
-
Question 12 of 20
12. Question
CorrectIncorrectHint
Use RANKX. To rank against everything, remove filters using ALL(DimensionTable).
-
Question 13 of 20
13. Question
CorrectIncorrectHint
Which function lets you “switch” between different outcomes based on a series of conditions?
-
Question 14 of 20
14. Question
CorrectIncorrectHint
Use SWITCH(TRUE(), Condition1, Result1, Condition2, Result2, ElseResult).
-
Question 15 of 20
15. Question
CorrectIncorrectHint
Variables let you store a calculated result and give it a name, making formulas cleaner.
-
Question 16 of 20
16. Question
CorrectIncorrectHint
Declare your VARiables first, then RETURN the final result.
-
Question 17 of 20
17. Question
CorrectIncorrectHint
Which function provides a result “IF” there is an “ERROR”?
-
Question 18 of 20
18. Question
CorrectIncorrectHint
Average = Total Value / Count of Items. Here, items are unique customers with sales.
-
Question 19 of 20
19. Question
CorrectIncorrectHint
Governance requires formal documentation. Where does the guide say to put this?
-
Question 20 of 20
20. Question
CorrectIncorrectHint
Which is generally more memory-intensive: storing a calculated value for every row (Column) or calculating an aggregate on demand (Measure)?