Forum Discussion

Mana_786's avatar
Mana_786
Frequent Visitor
8 years ago
Solved

Gross Margin

Hi Dear All, I hope some body can guide me properly .I have a probelm to get figures from Gross margin in Power BI. My Data type is somehow like this.   Branch No          Branch Name     Area   ...
Need Help
Tips and Tricks
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Mana_786,

    You need to create a measure to calculate the total Gross margin using the formula below.

    GM percentage = DIVIDE(SUM(Table1[GM]),SUM(Table1[Sales]))


    Please see the expected result, 40%=(1000+1000)/(3000+2000).



    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Mana_786,

You need to create a measure to calculate the total Gross margin using the formula below.

GM percentage = DIVIDE(SUM(Table1[GM]),SUM(Table1[Sales]))


Please see the expected result, 40%=(1000+1000)/(3000+2000).



Best Regards,
Angelia

gabriele's avatar
gabriele
Regular Visitor
7 years ago

In this solution there are a problem. If we have costs but revenue are 0, this formula return blank or optional value for zero division exception. I think that the real %profit must be " -100%"