Totals are incorrect in my table

[auzzieb]

I am getting an incorrect total in my table. I want the total to just be a sum of all the records in the column of my measure. I realize I need to change the context, but am unsure how best to do this. 

Currently I have the following Dax code in my measure. How can I alter this to just get a sum of the values in the below graphic?  

Power Price Paid - Optimized =

[KWh Hourly Usage - Optimized] * MAX('Meter Read Data'[Pool Price ($/Mwh)]) / 1000

[v-easonf-msft · Accepted solution]

Hi, @auzzieb 

Please add a new formula like:

Measure 1 = SUMX(VALUES(table),[Power Price Paid - Optimized])

Best Regards,
Community Support Team _ Eason