What is the difference between a measure and a calculated column?

Asked Viewed 29 times Solved
0

When should I create a measure and when a calculated column?

DAX and Transform AI Insights 365 Team

1 answer

0
Accepted answer

A calculated column is computed per row and stored (good for categories like 'Margin band'). A measure is computed at query time over whatever is filtered (good for totals and ratios like 'Margin %').

More detail: DAX measures and calculated columns

AI Insights 365 Team ·

Your answer

Know the answer? Sign in to help. It's free.