Calculated columns vs measures in Power BI - Dashboard Approaches Compared

Dashboard Mode - Calculated columns vs measures

Business Question

How do calculated columns and measures differ in Power BI, and when should you use each to analyze sales data?

Sample Data

Order ID	Product	Quantity	Unit Price	Region
1001	Notebook	2	15	East
1002	Pen	5	3	West
1003	Notebook	1	15	East
1004	Pen	10	3	North
1005	Binder	4	8	South
1006	Notebook	3	15	West

Dashboard Components

• KPI Card: Total Sales
  Formula (Measure): Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Unit Price])
  Result: 2*15 + 5*3 + 1*15 + 10*3 + 4*8 + 3*15 = 30 + 15 + 15 + 30 + 32 + 45 = 167
• Calculated Column: Sales Amount
  Formula: Sales Amount = Sales[Quantity] * Sales[Unit Price]
  This column is added to each row:
  Row 1: 2*15=30, Row 2: 5*3=15, Row 3: 1*15=15, Row 4: 10*3=30, Row 5: 4*8=32, Row 6: 3*15=45
• Table Visual: Shows Order ID, Product, Quantity, Unit Price, Sales Amount (calculated column)
• Bar Chart: Total Sales by Region
  Measure used: Total Sales
  East: 30 + 15 = 45, West: 15 + 45 = 60, North: 30, South: 32

Dashboard Layout

+----------------------+---------------------+
|      KPI Card        |     Bar Chart       |
|   Total Sales = 167  | Total Sales by Reg. |
+----------------------+---------------------+
|                Table Visual (Sales Data)   |
| Order ID, Product, Quantity, Unit Price,  |
| Sales Amount (Calculated Column)           |
+--------------------------------------------+

Interactivity

A slicer on Region filters the bar chart and the table visual. The KPI card updates the total sales measure based on the selected region. The calculated column Sales Amount remains static because it is computed row by row when data loads.

Self Check

If you add a filter for Region = East, which components update?

• The KPI card updates to show total sales for East: 30 + 15 = 45
• The bar chart shows only the East region bar with value 45
• The table visual shows only rows with Region East (Order IDs 1001 and 1003) with their Sales Amount
• The calculated column values stay the same but only rows matching the filter appear

Key Result

Dashboard comparing calculated columns and measures showing total sales and sales by region with interactivity.