What is the key difference between a calculated column and a measure?
- A A calculated column is computed at refresh and stored; a measure is computed at query time in filter context
- B A measure is stored in the model
- C Calculated columns respond to slicers
- D They are identical
Answer
A calculated column is computed at refresh and stored; a measure is computed at query time in filter context
Measures cost no memory and return the correct value at every level of aggregation, which is why they should be preferred.
Log in with Google
Log in with LinkedIn
.jpg)
.jpg)
