How to get the correct % variance in custom visual summary table of Power BI

[py0314]

Hi

This is a summary table which is a custom visual in Power BI where I use it to generate a PnL statement. I'm having an issue when trying to get the Material Margin % in SM & PM Variance. I couldn't get the correct percentage figure as what I highlighted in yellow. The correct figure should be 15.1%-20.6% = -5.5%. Instead it was showing me (-1255279/-473447)x100% = 265.1%. 

Might need help to get the formula in getting the correct figure. I have attached the json code that I used to generate the summary table in the link provided below. 

https://drive.google.com/file/d/1jkvpUjFMCXiVkfU5I71JAe1Fb8a5zKk2/view?usp=sharing

Help is much aprreciated. Thanks!

[Anonymous · Accepted solution]

HI @py0314,

It seems like a common measure total level calculation issue, you can take a look at the following blog if helps:

Measure Totals, The Final Word 

Regasrds,

Xiaoxin Sheng