✏️ Explanatory Question

What is the difference between a Measure and a Calculated Column?

👁 4 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Measure Calculated Column
Calculated at query time. Calculated during data refresh.
Consumes less memory. Consumes storage memory.
Dynamic based on filter context. Stored permanently in the model.

Measures are generally preferred whenever possible because they improve performance and reduce memory consumption.