Why is calculating a profit margin as a calculated column and then summing it wrong?
- A Summing percentages produces a meaningless total
- B Calculated columns cannot hold decimals
- C It uses too much memory
- D Percentages cannot be aggregated in Power BI
Answer
Summing percentages produces a meaningless total
The correct approach is a measure dividing the summed numerator by the summed denominator, which is right at every aggregation level.





