Use DAX Measures0%
Use DAX Measures
Beginner12 min read•Updated: Jul 11, 2026
Capstone Project: Use DAX Measures in Reports
Reading Time: 8 Mins | Level: Beginner to Advanced
1. The Core KPI Measure Suite
A professional Sales Dashboard requires a cohesive suite of measures:
DAX
// 1. Total Revenue
Total Revenue = SUM(Sales[Revenue])
// 2. Total Cost
Total Cost = SUM(Sales[Cost])
// 3. Gross Profit
Gross Profit = [Total Revenue] - [Total Cost]
// 4. Profit Margin %
Profit Margin % = DIVIDE([Gross Profit], [Total Revenue], 0)
// 5. Year-over-Year (YoY) Sales Growth
Sales SPLY = CALCULATE([Total Revenue], SAMEPERIODLASTYEAR(Calendar[Date]))
YoY Sales Growth % = DIVIDE([Total Revenue] - [Sales SPLY], [Sales SPLY], 0)
Interactive Quiz
Multiple Choice Questions
Question 1
Which DAX time-intelligence function calculates a measure evaluated against the exact same period in the previous year?
Question 2
What is 'Measure Branching' in DAX?
Question 3
What prerequisite is strictly required for DAX Time Intelligence functions (like
TOTALYTD or SAMEPERIODLASTYEAR) to compute accurately?Question 4
What function calculates cumulative Year-to-Date revenue in DAX?
Question 5
Why should you always format percentage measures explicitly as Percentage with 1 or 2 decimals in the Measure Tools ribbon?
Next Lesson
Apply Filters, Slicers, and KPIs
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
Related Lessons
| Previous Lesson | Next Lesson |
|---|---|
| Build an Interactive Sales Dashboard | Apply Filters, Slicers, and KPIs |
Practice Quiz
Test your understanding of this lesson with 5 questions. Each question has one correct answer.