Explanation of Calculated Column and Measure in SSAS

In SSAS, there is a difference between a calculated column and a measure.

Calculated Column:

A calculated column is a column that is defined in a table within the data model of SSAS. It is calculated using a formula that operates on other columns present in the same table. The calculated column's value is precomputed and stored in the data model, making it readily available for use in queries and calculations.

Measure:

A measure, on the other hand, is a value that is aggregated based on a specific calculation defined in the cube or tabular model. Measures are typically used in aggregations, such as sum, average, count, etc., and are not precomputed in the data model. Instead, they are calculated at query time based on the context of the query.

So, while a calculated column is a static value stored in the data model, a measure is a dynamic value computed at query time based on the data being queried.