Lära Your First Measures | Data Modeling and DAX Fundamentals

Svep för att visa menyn

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?

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 3. Kapitel 4

Fråga AI

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

Avsnitt 3. Kapitel 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?