Calculating Gross Profit Margin

[Anonymous]

Hi:

For Microsoft Dynamics 365 Business Central, I'm using the Chart of Accounts table and I'd like to calculate gross profit margin by subtracting cost of goods sold from revenue and dividing that figure by revenue.

How do I calculate this and place it in a report in Power BI?

Thanks!

John

[amitchandak · Accepted solution]

@Anonymous ,

If they are coming from two tables

calculate(divide((sum(Table2[revenue])-sum(Table1[COGS])),sum(Table2[revenue]))

From one table

calculate(divide(sumx(Table[revenue]- Table[COGS]),sum(Table[revenue])))

[Anonymous]

Thanks, for responding!

This still doesn't work, really. 

The following is what my report currently looks like, and the table is called Chart_of_Accounts.  If you can please modify your answer, that would be awesome!  😀

Account Category     Balance     Account No

Cost of Goods Sold   500000     50000

Income                      700000     40000

Income                        20000     41000

John

[Greg_Deckler]

I wrote a quick measure for gross margin: https://community.powerbi.com/t5/Quick-Measures-Gallery/Gross-Margin-Revenue-and-Cost-GMRC/m-p/58443...

Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490