Live training: next batches coming soon. Join the waitlist:Waitlists open:Developer Training →Developer →Copilot Studio Training →Copilot Studio →

Difference Between Calculated Column and Measure in Power BI

Calculated columns and measures are two important concepts of Power BI. Understanding the key differences between Calculated Columns and Measures will not only help you make better decisions but also optimize your Power BI model performance. In this Power BI tutorial, we will deep-dive into the difference between the calculated column and the measure in Power BI.

Calculated Column in Power BI

A Calculated Column is a column that you add to an existing table in the data model in Power BI. It’s computed during the data loading phase, and the values are stored in the Power BI model. The formula for a Calculated Column is calculated for each row in a table.

Example

To create a column in the Power BI desktop, click on the New column like below:

difference between calculated column and measure in Power BI

Then you can write a DAX expression like below:

Total Cost = Sales[Price]*Sales[Quantity]
difference between calculated column and measure power bi

The above DAX expression will calculate values by multiplying the two columns, Price and Quantity column, from the Sales table.

You can see the output below:

power bi difference between measure and calculated column

If you add the data in a Tab