Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Total is wrong

Hello,    I have calculated measure Total_LC as given below    Total_LC = VAR F12 = SUM('NCC Chart''s'[F12]) VAR H12 = SUM('NCC Chart''s'[H12]) RETURN (average('NCC Chart''s'[Net_NCC_Cost])+ ...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power-BI do not just sum the values in the column. 

It actually executes the formula for the row in total. 

 

So, based on your formula and the screen-shot you provided. 

 

average('NCC Chart''s'[Net_NCC_Cost])  = -1,105,559.14

 

 

H12 - F12 ( 0.2020 - 1.3160) is not greater than 0 
So your calcualtion is -H12 + F12 (-0.2020 + 1.3160) * 1000000 = 1,114,000

 

-1,105,559.14 + 1,114,000 = 8440.86