- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Gross Margin, Revenue and Cost (GMRC)
12-12-2018
12:30 PM
Here are a few common calculations, Gross Margin %, Revenue and Cost.
So, given Revenue and Cost, what is my gross margin %?
GM % = DIVIDE(( SUM([Revenue]) - SUM([Cost]) ),SUM([Revenue]),0)
Given Cost and desired Gross Margin %, what should my Revenue be?
Revenue Measure = IF(HASONEVALUE(Revenue[Person]),DIVIDE(SUM([Cost]),( 1 - SUM(Revenue[GM])),0),SUMX(SUMMARIZE(Revenue,[Person],"__Revenue",DIVIDE(SUM([Cost]),( 1 - SUM(Revenue[GM])),0)),[__Revenue]))
Given Revenue and desired Gross Margin, what should my Cost be?
Cost Measure = IF(HASONEVALUE(Revenue[Person]),SUM([Revenue])*(1 - SUM(Cost[GM])),SUMX(SUMMARIZE(Revenue,[Person],"__Cost",SUM([Revenue])*(1 - SUM(Cost[GM]))),[__Cost]))
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2020
04:11 PM
What do you do when you have a dynamic margin? In your example, you have used 45% consistent as a margin to find the cost. I want to use random % to find my cost based on sales. Is it possible?

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2020
09:41 AM
This still doesn't work, really. Here is a screenshot, if you can please modify your answer based on that
Thanks, for responding!
John
