Forum Discussion

Yuiitsu's avatar
Yuiitsu
Helper V
6 years ago
Solved

Calculating Margin %

Dear Experts   I am new with Power BI so I really need help here. Forgive me if this had been answered somewhere else but I cannot seem to find a solution around.   I want to create a graph to sh...
Need Help
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Yuiitsu ,

     

    One custmer may have multi margins%, so if we sum them, we may got a 38%+30%+30% for customer C, if you want to get the result (3+10+34)/(11+32+88)=35.8%, we can create a measure as the value fileld to meet your requirement:

     

    Margin % Measure =
DIVIDE ( SUM ( 'Table'[Profit] ), SUM ( 'Table'[Total Selling] ) )


    Best regards,

     

     

Yuiitsu's avatar
Yuiitsu
Helper V
6 years ago

Thank you for your kind reply. Please take a look at my screenshot

 

should I change to 2 decimal place? If yes please guide me the steps.

Also for the margin, as you can see in the SS i set it to dont summarize.

The drop down doesnt have that option. Am I misunderstanding anything here?

 

Again thank you for your help!

 

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Yuiitsu ,

 

One custmer may have multi margins%, so if we sum them, we may got a 38%+30%+30% for customer C, if you want to get the result (3+10+34)/(11+32+88)=35.8%, we can create a measure as the value fileld to meet your requirement:

 

Margin % Measure =
DIVIDE ( SUM ( 'Table'[Profit] ), SUM ( 'Table'[Total Selling] ) )


Best regards,

 

 

  • Yuiitsu's avatar
    Yuiitsu
    Helper V
    6 years ago

    Thank you very much!