Calculated columns vs measures in Power BI - Formula Comparison Trace

Sample Data

This table shows products with their price and quantity sold. Column D is a calculated column multiplying Price and Quantity for each row. Column E is a measure calculating total sales across all products.

Cell	Value
A1	Product
B1	Price
C1	Quantity
D1	Total Sales (Calculated Column)
E1	Total Sales (Measure)
A2	Apple
B2	2
C2	10
A3	Banana
B3	1
C3	20
A4	Cherry
B4	3
C4	5

Formula Trace

Total Sales (Calculated Column) = Price * Quantity Total Sales (Measure) = SUM('Table'[Total Sales (Calculated Column)])

Step 1: Price (B2) * Quantity (C2)

Step 2: Price (B3) * Quantity (C3)

Step 3: Price (B4) * Quantity (C4)

Step 4: SUM of all calculated column values (20 + 20 + 15)

Cell Reference Map

    A       B       C       D       E
1 |Product| Price |Quantity|Total Sales|Total Sales
  |       |       |        |(Calc Col)| (Measure)
2 | Apple |   2   |   10   |    20    |   55
3 |Banana |   1   |   20   |    20    |   55
4 |Cherry |   3   |    5   |    15    |   55

Columns B and C are used to calculate the Total Sales in column D for each row. The measure in column E sums all these calculated values.

Result

    A       B       C       D       E
1 |Product| Price |Quantity|Total Sales|Total Sales
  |       |       |        |(Calc Col)| (Measure)
2 | Apple |   2   |   10   |    20    |   55
3 |Banana |   1   |   20   |    20    |   55
4 |Cherry |   3   |    5   |    15    |   55

The calculated column (D) shows total sales per product row. The measure (E) shows the total sales sum across all products, repeated for display.

Sheet Trace Quiz - 3 Questions

What does the calculated column 'Total Sales (Calculated Column)' show?

A Total sales for each product row

B Sum of all sales across products

C Average price of products

D Quantity sold for all products

Key Result

Calculated columns compute row-level values; measures compute aggregated values over rows.