✏️ Explanatory Question

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

👁 3 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Feature Calculated Column Measure
Storage Stored in model Calculated at runtime
Memory Usage Consumes memory No storage cost
Aggregation Limited Designed for aggregation
Performance May increase model size Generally more efficient

Architects typically prefer Measures whenever possible.