Calculated columns vs measures in Power BI - Compared

Introduction

Calculated columns and measures help you create new data from your existing data. Calculated columns add new data to each row in your table. Measures calculate results based on filters and show summary numbers.

When you want to add a new column that shows a value for each row, like profit per sale.

When you need a total or average that changes when you filter your report, like total sales by region.

When you want to create a new field that depends on other columns in the same row.

When you want a number that updates dynamically as you explore your data.

When you want to use the new data in slicers or as part of table visuals.

Steps

Step 1: Click

- Data view in Power BI Desktop

You see your tables and their columns listed

💡 Use Data view to work with calculated columns

Step 2: Click

- New column button on the Modeling tab

A formula bar appears to enter a DAX formula for the calculated column

Step 3: Type

- Formula bar

The new column is added to the table with values calculated for each row

💡 Example formula: Profit = Sales[Revenue] - Sales[Cost]

Step 4: Click

- New measure button on the Modeling tab

A formula bar appears to enter a DAX formula for the measure

Step 5: Type

- Formula bar

The measure is created and appears in the Fields pane under the table

💡 Example formula: Total Profit = SUM(Sales[Revenue]) - SUM(Sales[Cost])

Step 6: Add

- Visual on the report canvas

Use the calculated column or measure in your visuals to see row-level or aggregated results

Before vs After

Before

Table has columns: Revenue and Cost with 100 rows of sales data

After

Table has a new calculated column 'Profit' showing Revenue minus Cost for each row; also a measure 'Total Profit' that sums revenue minus cost dynamically in visuals

Settings Reference

Data view

📍 Left side vertical bar in Power BI Desktop

Switch to Data view to create calculated columns

Default: Report view

New column

📍 Modeling tab on the ribbon

Create a calculated column with a DAX formula

Default: Not created

New measure

📍 Modeling tab on the ribbon

Create a measure with a DAX formula

Default: Not created

Common Mistakes

Using a calculated column when a measure is needed for aggregation

Calculated columns do not change with filters and can increase data size unnecessarily

Use a measure to calculate totals or averages that respond to report filters

Using a measure when row-level data is needed

Measures only return aggregated results, not values per row

Use a calculated column to create new data for each row

Summary

Calculated columns add new data to each row and are stored in the table.

Measures calculate results dynamically based on filters and show aggregated values.

Choose calculated columns for row-level data and measures for summaries that change with filters.