What is the difference between calculated columns and measures?

Question

Accepted Answer

Calculated columns are computed during data loading, while measures are computed on the fly during data visualization.

Calculated columns are created in the data model and stored in the underlying table.
Measures are created using DAX expressions and are calculated dynamically based on the context of the visualization.
Calculated columns consume memory and can impact performance, while measures are more efficient.
Calculated columns are useful for static calculations, while measures are used for aggregations and calculations based on user interactions.
Example: Calculated column - Age = YEAR(TODAY()) - YEAR([Birthdate])
Example: Measure - Total Sales = SUM([Sales])

Accepted Answer

a calculated column is evaluated aggregations of each row and Measures are evaluated by columns in a table

Accepted Answer

Calculated columns takes some memory space as to store the data into a column which can later be used in filters and slicers, on the other hand measures are only the calculation which cannot be used as filter or slicer and it did not take any memory

Asked in Infosys

What is the difference between calculated columns and measures?

Top Power BI Developer Interview Questions Asked at Infosys

Interview Questions Asked to Power BI Developer at Other Companies

Top Skill-Based Questions for Infosys Power BI Developer