calculated columns, sum, dividing

[puj831]

Hi all, 

I am trying to figure out how to create the following calculated column in PowerBI. I am trying to do C1 (column H) * C2 (column I) by row that would give us column J (not literally trying to create column J in PowerBI), then taking the sum of column J and dividing that number by the sum of C2 (column I) which would give me a final answer of 43.48921. Any suggestions? Thanks so much!!!

[Anonymous · Accepted solution]

Hi

I hope this is what you are looking for.

Measure 2 = sumx(Calc,Calc[C1]*Calc[C2])/ SUM(Calc[C2])

Thanks

Raj