Column totals are not correct!

[k3rz0rg]

Hi everyone, 

I'm having this weird issue and desparately looking for a solution for this.
I have 3 measures which are Count, Average and Count * Average , the total of Average and Count * Average are not giving me the correct total as shown below : 

As you can see the total for the Average and the Count * Average are not the expected total I need.
I tried SUMX(Table, (Count * Average)) technique but no avail. 
Any calculation that will give me $3,434,682 for the Average and $6,363,700 for the for the Count * Average column would be great help! 

Thanks!

[Ahmedx · Accepted solution]

you need creat 2 measures

1)  m1 = Count * Average

2) m2 = SUMX( VALUES('Table'[ID]), [m1])

[k3rz0rg]

Spot on! This seems to be working in my case. I tried using SUMX without the VALUES() function and just the table/column name which didn't work but this did.