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!