Calculate MAX seems to put MAX value on total line

[BenBernanke]

First time posting but just trying to figure out what im doing wrong here.

MEASURE:

Prior Total Costs =

   CALCULATE([Total Costs],

   FILTER(ALLSELECTED(Calendar1[Date]),

  Calendar1[Date]<= MAX(Calendar1[Prior Plan Year Lookup Date])))

Screenshot:

Need it to return the total between the months not the max value.

[Ashish_Mathur]

What exactly are you trying to do?  Explain the question in simple English rather than just pasting a measure.  Show the expected result very clearly.  Share the download link of the PBI file.

[amitchandak]

@BenBernanke , Grand total is recalculated so it will give the last month in total

You can have a measure like

MEASURE:

Prior Total Costs =

Sumx(Calendar1[Month Year] ) ,  // Assumed month Year is on column

   CALCULATE([Total Costs],

   FILTER(ALLSELECTED(Calendar1[Date]),

  Calendar1[Date]<= MAX(Calendar1[Prior Plan Year Lookup Date])))

)