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 7, Planning Power BI Projects, and thus contain validated and approved business definitions. For Adventure Works, a set of 12 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'[Unit Price]*'Reseller Sales'[Order Quantity]) Reseller Net Sales = [Reseller Gross Sales] - [Reseller Sales Discounts] Reseller Sales Product Cost = SUMX('Reseller Sales', 'Reseller Sales'[Order Quantity]*'Reseller Sales'[Product Standard Cost]) Reseller Cost of Sales = [Reseller Sales Product Cost] + [Reseller Sales Freight Cost] Reseller Gross Product Margin = [Reseller Gross Sales] - [Reseller Sales Product Cost] Reseller Gross Product...