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

Sveip for å vise menyen

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?

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 4

Spør AI

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

Seksjon 3. Kapittel 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?