Learn Your First Measures | Data Modeling and DAX Fundamentals

Swipe to show menu

This chapter is where your model starts producing real answers. You'll write DAX measures that form the foundation of the Summit Gear Co. dashboard: Total Sales, Order Count, Average Order Value, Unique Customers, and Profit Margin.

Along the way you'll learn the difference between implicit and explicit measures, when to use DISTINCTCOUNT instead of COUNT, how to compose a measure from other measures using DIVIDE, and how to calculate true profit margin using SUMX and RELATED to work across tables. By the end, you'll have a working KPI row and a category breakdown that updates dynamically with any filter in the report.

1. You want to count the number of orders placed. The Sales table has one row per order line item, meaning a single order with three products appears as three rows. Which DAX function gives you the correct order count?

2. Why is `DIVIDE([Total Sales], [Order Count])` preferred over `[Total Sales] / [Order Count]` when writing the Avg Order Value measure?

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 4

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Section 3. Chapter 4

Your First Measures

1. You want to count the number of orders placed. The Sales table has one row per order line item, meaning a single order with three products appears as three rows. Which DAX function gives you the correct order count?

2. Why is DIVIDE([Total Sales], [Order Count]) preferred over [Total Sales] / [Order Count] when writing the Avg Order Value measure?

2. Why is `DIVIDE([Total Sales], [Order Count])` preferred over `[Total Sales] / [Order Count]` when writing the Avg Order Value measure?