学ぶ Your First Measures | Data Modeling and DAX Fundamentals

メニューを表示するにはスワイプしてください

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?

すべて明確でしたか？

フィードバックありがとうございます！

セクション 3. 章 4

AIに質問する

何でも質問するか、提案された質問の1つを試してチャットを始めてください

セクション 3. 章 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?