Divide sum of one column by sum of another column

[KAchukatla]

Dear Team, 

I have  trying to divide 2 columns but it is not giving accurate number. For Eg. 

Project A 

CO2 Emitted in Tons, Jan=215, Feb=315,Mar=123 , TOTAL= 438

Area in m3,Jan=120,Feb=150.Mar=100 , TOTAL = 370

CO2 footprint tons /M2 YTD for projectA = 438/370 = 1.8  CORRECT, 

But system is calculating for eah month and adding up the values as shown below

CO2footprint/m2, Jan = 1.8, Feb=2.1 , Mar=1.23 , 

YTD = 5.13  WORNG . 

It is simple divid funtion to divide Total Sum Column A(CO2 emitted) by Total Sum of COlumn B(area).

Kindly let me know if you need more infomration 

[Greg_Deckler · Accepted solution]

I'm not quite sure about your math here.

First, the CO2 emitted with your numbers adds up to 653, not 438.

The area number is correct.

Second, 438/370 does not equal 1.8, it equals 1.18

Now, 653/370 = 1.76

Now, if I create a measure like:

Measure = SUM([CO2]) / SUM([Area])

The total line comes out to 1.76, which is correct. This is in a table with Month, CO2 and Area columns.

And people wonder why there are still global warming skeptics... 🙂

[KAchukatla]

Hi Smoupre, 

I am new to the power BI and thank you for the providing assistance in fixing the issue.   

Really i do not why i did the worng calculation 🙂 .