HASONEFILTER SUMX total not calculating correctly

Question

I am creating a Power BI measure that sums up averages so I have used the HASONEVALUE SUMX method but the total doesn't match what the actual sum would be if you just add up the information. Here is the measure:

And here is the results:

The total shows 31,654.25 but if you add up the rows you actually get 22,962.33. I am wondering if there is something wrong with my measure or if it is an issue of me not realizing it is pulling in additional information I'm not aware of.

Answer 1

Adding to @Alexis Olson, the average in a row is for the group, the total count is for entire datatable.

Below table is grouped by column A. Sum of averages is not equal to total average