Base measures

Before any custom or complex DAX measures can be developed, a set of relatively simple base measures must be implemented first. These measures represent the metrics from the Define the facts section of Chapter 1, Planning Power BI Projects, and thus contain validated and approved business definitions.

For Adventure Works, a set of base measures related to sales, cost, and margins are applicable to both the Internet Sales and Reseller Sales fact tables, such as the following:

Reseller Gross Sales = SUMX('Reseller Sales', 'Reseller Sales'[UnitPrice] * 'Reseller Sales'[OrderQuantity])
Reseller Sales Discounts = SUM('Reseller Sales'[DiscountAmount])
Reseller Net Sales = [Reseller Gross Sales] - [Reseller Sales Discounts]
Reseller Sales Product Cost = SUMX('Reseller Sales', 'Reseller Sales'[OrderQuantity] * 'Reseller Sales'[ProductStandardCost])  
Reseller Sales Freight Cost = SUM('Reseller...