Would you use a measure or calculated column for a margin that must change with report selections?

Instruction: Use a metric you understand. Keep the difference between a fixed classification and a user-selected threshold clear.

Context: Chooses the calculation from interaction and grouping requirements, with an explicit Import-model qualifier and a check for aggregation mistakes.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

I'd use a measure for the selected period's profit margin because the result must recalculate when users change date, region, or product filters. I'd aggregate profit and revenue in that context, then calculate their ratio...

Upgrade to view official answer

Related Questions