Practice and Answer Key: Calculated Columns vs Measures

Suppose we are checking discounts and delivery speed for the Blinkit Maharashtra team. Use src/practice/column_vs_measure_orders.csv (fictional practice data):

About this data: This table uses columns: Order ID, City, Amount (₹), Discount (₹), Delivery Time Mins, Order Status. This table uses columns: City, Total Sales, Net Sales, Delivered, % Under 10 Mins, Discount % (measure), Average of Disc % (row). This table uses columns: What you see, Why, Fix. Values shown are the lesson examples already on this page (not a new dataset).

Exercise (one under the other):

1. Load the CSV. In Power Query, Add Column › Conditional Column Speed Band: if Delivery Time Mins equals null → "No delivery"; else if it is ≤ 10 → "Fast"; else "Slow".
2. Write measures Total Sales, Net Sales (Amount minus Discount, row by row) and Delivered Orders.
3. Write % Under 10 Mins = delivered orders with 10 minutes or less ÷ delivered orders.
4. Write Discount % as a measure. Then make a calculated column Disc % (row) and put its average next to it.
5. Build a matrix with Rows = City and compare.

Expected result (check your numbers):

Speed Band: 201 Fast, 202 Slow, 203 Fast, 204 Slow, 205 No delivery. Net Sales total = 1,900 − (50 + 100) = ₹1,750.

Total Sales      = SUM(Orders[Amount])
Net Sales        = SUMX(Orders, Orders[Amount] - Orders[Discount])
Delivered Orders = CALCULATE(DISTINCTCOUNT(Orders[Order ID]), Orders[Order Status] = "Delivered")
% Under 10 Mins  = DIVIDE(CALCULATE([Delivered Orders], Orders[Delivery Time Mins] <= 10), [Delivered Orders])
Discount %       = DIVIDE(SUM(Orders[Discount]), SUM(Orders[Amount]))

-- calculated column (only to see the mistake)
Disc % (row)     = DIVIDE(Orders[Discount], Orders[Amount])

Common mistakes:

Samajla ka? Row facts in columns, totals and ratios in measures.