Home / Questions / What is the difference between Calculated Columns and Measures?
Explanatory Question

What is the difference between Calculated Columns and Measures?

👁 0 Views
📘 Detailed Answer
🕒 Easy to Read
Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

Calculated Column Measure
Stored in the model Calculated at runtime
Consumes memory Consumes CPU during execution
Evaluated row by row Evaluated using filter context
Static after refresh Dynamic based on report filters

Measures are generally preferred for better model performance.