Need to Sum by year using DAX

[brockry1]

I have data for 2024 and 2025 in the "Mars Year" column and need to sum the "Actual Tonnage" as a measure to sum total 2024 and total 2025.  I've tried a few calculations but it's not bringing back what I need.  Any suggestions would be helpful. 

[DataInsights · Accepted solution]

@brockry1,

Try this measure:

Actual Tonnage 2024 and 2025 =
CALCULATE (
    SUM ( MyTable[Actual Tonnage] ),
    MyTable[Mars Year] IN { 2024, 2025 }
)