topic Re: Gross Margin, Revenue and Cost (GMRC) in Quick Measures Gallery

Gross Margin, Revenue and Cost (GMRC)

Greg_Deckler — Wed, 12 Dec 2018 20:30:33 GMT

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]))

eyJrIjoiYTFhNzBkNTMtY2NkNS00YmZiLWE5ZGUtOTJhOWI5ZWY4YWE0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

Re: Gross Margin, Revenue and Cost (GMRC)

Anonymous — Thu, 19 Mar 2020 16:41:56 GMT

This still doesn't work, really. Here is a screenshot, if you can please modify your answer based on that

Thanks, for responding!

John

Re: Gross Margin, Revenue and Cost (GMRC)

rahulvyas — Fri, 18 Dec 2020 00:11:48 GMT

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?