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

Cancel reply