How do I write a Margin % measure?

Asked Viewed 30 times Solved
0

I need profit divided by sales as a percentage that works with filters.

DAX and Transform AI Insights 365 Team

1 answer

0
Accepted answer

Create a measure: Margin % = DIVIDE(SUM([Profit]), SUM([Sales])). DIVIDE returns blank instead of an error when sales are zero.

More detail: DAX measures and calculated columns

AI Insights 365 Team ·

Your answer

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