How to calculate percentage correct in each Row level by Calculation Column in Matrix?

[TungNguyen_19]

Hi everyone,

I stuck this problem when calculate the "% Margin" for each row level (please see detail in the picture below)

"Total Revenue" and "Profit/Loss" are calculation column and use Matrix to summary by all dimension for each row level.

Problem is only the last level is calculated percentage correctly. But the upper row level sum up every below rows rather than using the fomular to calculate percentage? 😓

 

 The fomular is:

% of Margin = DIVIDE('3 LOAD FULL'[Profit/Loss],'3 LOAD FULL'[Total Revenue],0)

 I don't know what was wrong of my implementation. Please help me, thank you ❤️ 

[amitchandak · Accepted solution]

@TungNguyen_19 , I am assuming these are measures other wise you need a measure like

% of Margin = DIVIDE(Sum('3 LOAD FULL'[Profit/Loss]),Sum('3 LOAD FULL'[Total Revenue],0) )

% of Margin needs to be a measure

[TungNguyen_19]

Thank you @amitchandak It's true, I need to use Measure rather than another Calculation Column. Thank you very much ❤️