What is the basic difference between a calculated column and a measure?

Question

Accepted Answer

Calculated columns are static values calculated at the row level, while measures are dynamic values calculated at the aggregated level.

Calculated columns are computed for each row in a table, while measures are computed for the entire dataset or a subset of data.
Calculated columns are stored in the data model, while measures are calculated on the fly based on user interactions.
Examples of calculated columns include age calculated from birthdate, while examples of measures include sum of sales or average temperature.
Calculated columns are useful for adding new data to a table, while measures are used for performing calculations on existing data.

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 We17 and 11 others

What is the basic difference between a calculated column and a measure?

Interview Questions from Popular Companies