Now that we have the data model set up, I need a set of core DAX measures for the margin analysis. These will drive the margin dashboard.

Please create the following measures in a dedicated measures table called Margin Measures:

Revenue (₦) Total line_total from order_items, excluding orders with status cancelled, returned or refunded. This is what we actually collected.

Cost of Goods (₦) Total quantity × cost_price_cents / 100 per order item. This is what the products cost us.

Gross Margin (₦) Revenue (₦) minus Cost of Goods (₦). This is the profit before operating expenses.

Gross Margin % Gross Margin (₦) divided by Revenue (₦). Use DIVIDE to handle divide-by-zero. This is the margin as a percentage of revenue.

List Price Revenue (₦) Total quantity × list_price_cents / 100 per orde…