Summary  
This chapter demonstrates how to model data and define DAX measures by creating a date dimension with calculated columns, establishing star‐schema relationships between tables, and writing DAX formulas (SUM, DISTINCTCOUNT, DIVIDE, SUMX, RELATED, AVERAGE) to compute key metrics.

General domain of usage  
Sales performance analytics

The solution walkthrough for creating relationships and DAX measures. After attempting the build on your own, watch this chapter to compare your approach with the reference solution. You will create the star schema and relationships amongst all your tables, as well as create six measures in total: Total Sales, Order Count, Avg Order Value, Profit Margin, Avg Discount, and Margin vs Target.

Master the skills needed to turn raw data into professional, interactive reports using Power BI. You'll connect to data sources, clean and transform data with Power Query, build data models, write DAX measures, and publish polished dashboards to Power BI Service. No prior experience required.

Relationships and DAX