What is the difference between measure and calculated column?

< 1 min read

The main difference is when and how they are calculated.
A calculated column is computed row by row during data refresh and stored in the model.
A measure is calculated at query time based on filter context.
Calculated columns increase model size because values are physically stored.
Measures do not store data; they compute results dynamically.
For example, I use a calculated column to create a Customer Category flag.
I use a measure to calculate Total Sales or Profit % for dashboards.
If the requirement is row-level logic or relationships, I use a calculated column.
If it is aggregation or KPI-based reporting, I use a measure.

Power BI Essentials