In Power BI, both Calculated Columns and Measures are created using DAX, but they serve different purposes and behave differently inside the data model.<\/p>\n\n\n\n
A calculated column performs a row-by-row calculation and stores the result inside the data model.<\/p>\n\n\n\n
Profit = Sales[Revenue] - Sales[Cost]<\/pre>\n\n\n\nHere, the calculation is performed for every row in the Sales table and saved in the model.<\/p>\n\n\n\n
When to Use Calculated Columns<\/h3>\n\n\n\n
\n
- When you need a new field for categorization<\/li>\n\n\n\n
- When you want to create relationships based on the new column<\/li>\n\n\n\n
- When the value does not need to change dynamically based on visuals<\/li>\n<\/ul>\n\n\n\n
Measures<\/h2>\n\n\n\n
A measure performs dynamic calculations based on filter context. It is not stored in the model but calculated at query time.<\/p>\n\n\n\n
Key Characteristics<\/h3>\n\n\n\n
\n
- Calculated when used in a visual<\/li>\n\n\n\n
- Not stored physically in the model<\/li>\n\n\n\n
- Does not increase model size significantly<\/li>\n\n\n\n
- Works at aggregation level<\/li>\n\n\n\n
- Changes based on filters, slicers, and visuals<\/li>\n<\/ul>\n\n\n\n
Example<\/h3>\n\n\n\n
Total Profit = SUM(Sales[Revenue]) - SUM(Sales[Cost])<\/pre>\n\n\n\nThis calculation changes depending on the filters applied in the report.<\/p>\n\n\n\n
When to Use Measures<\/h3>\n\n\n\n
\n
- When you need dynamic totals, averages, or KPIs<\/li>\n\n\n\n
- When calculations depend on filters or slicers<\/li>\n\n\n\n
- For dashboards and summary-level reporting<\/li>\n<\/ul>\n\n\n\n
Main Differences<\/h2>\n\n\n\n
Calculated Columns are static and row-based, while Measures are dynamic and context-based.<\/p>\n\n\n\n
Calculated Columns increase model size because values are stored, whereas Measures calculate results only when needed.<\/p>\n\n\n\n
Calculated Columns are mainly used for data modeling, while Measures are primarily used for reporting and analysis.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Use Calculated Columns when you need row-level data stored in the model. Use Measures when you need dynamic calculations that respond to filters and user interactions. Understanding the difference is essential for building efficient and optimized Power BI reports.<\/p>\n\n\n\n
<\/strong><\/p> <\/div> <\/div>\n\n\n