Calculated Columns & Measures in Power BI

Gabriel Madichie 100

Hi, I would like to know - what exactly are the key differences between calculated columns and measures?

Syed Saleem Peera 11,005 Reputation points Microsoft Vendor

2025-01-30T05:52:21.6166667+00:00

Hi Gabriel Madichie,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.

1 answer

Syed Saleem Peera 11,005 Reputation points Microsoft Vendor

2025-01-28T12:03:41.0366667+00:00
Hi Gabriel Madichie,

Thank you for reaching out on the Microsoft Q&A forum.

In Power BI, calculated columns and measures are both used to create custom calculations, but they serve different purposes and behave differently:

Calculated Columns: These are used for row-level calculations, where the result is stored in the data model. They take up memory and are calculated when the data is loaded or refreshed.

Measures: These are used for aggregations (like SUM, AVERAGE) and are calculated dynamically based on the context of your report (filters, slicers). Measures don’t store data and don’t take up memory.

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members.

Thank you.
Please sign in to rate this answer.
Syed Saleem Peera 11,005 Reputation points Microsoft Vendor

2025-01-29T09:28:13.5166667+00:00

Hi Gabriel Madichie,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.

Syed Saleem Peera 11,005 Reputation points Microsoft Vendor

2025-01-30T13:27:42.66+00:00

Hi Gabriel Madichie,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Calculated Columns & Measures in Power BI

1 answer

Your answer