Forum Discussion
Calculating Margin %
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,
Is this what you meant?
Thanks for your reply earlier!
Yes, thankyou, in the value field you see count of margin, this should be set to dont summarize. Also, did you chance the data to 0,66 instead of 66%?
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!
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!