Calculate Average of a Measure

[RachelQ]

Gallons consumed is a measure that is supposed to take the Sum of Total Miles divided by the Average MPG. MPG is also a measure that is Sum of Total Miles divided by Sum of Gallons Purchased. 
So ideally, it would be 

IL - 327053.96 / 5.70 = 57377.89 gallons consumed
IN -  573683.22 / 5.70 = 100646.18 gallons consumed
OH - 35671.18 / 5.70 = 6258.10 gallons consumed

But right now it is diving by 9.87, 4.51. and 9.37 and just equaling the sum of gallons purchased.

How can I get it to divide by the average of the MPG on my table?

[sjoerdvn · Accepted solution]

Gallons Consumed = DIVIDE(SUM(Table[Total Miles]), CALCULATE([MPG],ALL()))