Lære Your First Measures | Data Modeling and DAX Fundamentals

Stryg for at vise menuen

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 alt klart?

Tak for dine kommentarer!

Sektion 3. Kapitel 4

Spørg AI

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Sektion 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?