https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-of-a-Measure/m-p/4624502#M177013 <P>Gallons Consumed = DIVIDE(SUM(Table[Total Miles]), CALCULATE([MPG],ALL()))</P> Tue, 25 Mar 2025 16:25:09 GMT sjoerdvn 2025-03-25T16:25:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-of-a-Measure/m-p/4624260#M177005 <P><img /></P><P><BR />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.&nbsp;<BR />So ideally, it would be&nbsp;<BR /><BR />IL - 327053.96 / 5.70 = 57377.89 gallons consumed<BR />IN -&nbsp; 573683.22 / 5.70 = 100646.18 gallons consumed<BR />OH - 35671.18 / 5.70 = 6258.10 gallons consumed<BR /><BR />But right now it is diving by 9.87, 4.51. and 9.37 and just equaling the sum of gallons purchased.<BR /><BR />How can I get it to divide by the average of the MPG on my table?</P> Tue, 25 Mar 2025 13:47:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-of-a-Measure/m-p/4624260#M177005 RachelQ 2025-03-25T13:47:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-of-a-Measure/m-p/4624502#M177013 <P>Gallons Consumed = DIVIDE(SUM(Table[Total Miles]), CALCULATE([MPG],ALL()))</P> Tue, 25 Mar 2025 16:25:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-of-a-Measure/m-p/4624502#M177013 sjoerdvn 2025-03-25T16:25:09Z