Forum Discussion

Yuiitsu's avatar
Yuiitsu
Icon for Helper V rankHelper 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,

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You want to save a percentage as a decimal and then label it as percentage in modelling tab. 0,66 = 66%. The way you have it now is 66% = 6600% (66*100).

Im not sure whats going on in your visual, but i advice you to change this first and then take a look at the visual. If its still not working please post the setup of the visual, what fields are where on what aggregation etc.