Calculating sales margin %

[AbbasG]

Hello All,

I have calculated the Sales margin value as below.

Sales Margin = SUM('Total Sales'[Total Sales Amount]) - (SUM(Cost[TCost]) + SUM(cog[Amount]))

cog = Cost of goods sold

Tcost = Total cost

I also want to calculate sales margin %. What would be the right query to achieve sales margin %?

[AbbasG]

@amitchandak thank you so much Amit.

[amitchandak · Accepted solution]

@AbbasG , Try like

Sales Margin %= divide(SUM('Total Sales'[Total Sales Amount]) - (SUM(Cost[TCost]) + SUM(cog[Amount]), SUM('Total Sales'[Total Sales Amount]) )  )