Power BI Interview Questions
What is the difference between a Calculated Column and a measure?
Table of Contents
| Feature | Measure | Calculated Column |
|---|---|---|
| Definition | A dynamic aggregation or calculation performed based on the report’s filters and context. | A static calculation that is evaluated row by row in the data model. |
| Calculation Context | Calculated based on the context of the report (e.g., filters, rows, columns). | Evaluated once for each row in the data table when data is loaded or refreshed. |
| Storage | Does not consume additional memory in the data model as it is computed dynamically. | Stored in the data model as part of the table, increasing the model’s size. |
| Usage | Used primarily in visualizations to aggregate or summarize data dynamically. | Used to create new columns for analysis and filtering, often for row-level calculations. |
| Recalculation | Recalculated each time the context of the report changes (e.g., when filters are applied). | Calculated once and remains static unless the data model is refreshed. |
| Example | Total Sales = SUM(Sales[Amount]) | Sales Category = IF(Sales[Amount] > 1000, “High”, “Low”) |
| Performance Impact | More efficient, as calculations happen dynamically based on filters. | Can increase memory usage, especially with large datasets. |
| Availability in Visuals | Directly used in visualizations for dynamic calculations. | Available for use in visualizations but more useful for categorization or filtering. |
Single
Enrich our growing community.
- General admission and member discounts for one adult
- One free ticket per special exhibition
- Two single-use guest passes per year
Family
Support special exhibitions.
- General admission and member discounts for two adults
- Four free tickets per special exhibition
- Four single-use guest passes per year
Add comment