Profit margin ratio

The profit margin ratio compares the total profit to the total sales. It's an important financial metric and it's always expressed as a percentage.

In this exercise, you will create a measure to represent the profit margin ratio. TotalSales has already been calculated for , but we need Total Profit. Luckily, in an earlier exercise, we created a Profit column that we can use to make our Total Profit measure.

There are two ways to calculate this, one way is by using DIVIDE()function.

If you lost progress, close any open reports and load 1_3_profit_margin_ratio.pbix from the Exercises folder.