What is difference between calculate column 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

What is difference between calculate column and measures?

Top Infosys Power BI Developer interview questions & answers

Popular interview questions of Power BI Developer

Top HR questions asked in Infosys Power BI Developer