Forum Discussion
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...
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,
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,
Thank you very much!