How do I write a Margin % measure?
0
I need profit divided by sales as a percentage that works with filters.
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
Your answer
Know the answer? Sign in to help. It's free.