Calculated Measure

gancw1 , Most recent or two most recent, based on selection or over all

You can try like

measure =

var _max = maxx(allselected(Table), Table[Date])

return

calculate(sum(Table[Num return]), filter(Table, Table[Date] =_max))

Hi gancw1 ,

• Condition1: Every date has Num:

You could simply use the "Sum" type of summarization for [Num Return]

Or use :

Measure = CALCULATE(SUM('Table'[Num return]),ALLEXCEPT('Table','Table'[Date]))

• Condition2: There are blank values in Table:

Based on the keyword ——" the most recent date", I used another table by adding 1/24/2022 

Since 1/24/2022 has no value ,it should get sum from the most recent date=2022/1/22  =14

Measure2 = 
var _max= MAXX(FILTER(ALL('Table (2)'),[Date]<=MAX('Table (2)'[Date]) && [Num return]<>BLANK()  ),[Date])
return CALCULATE(SUM('Table (2)'[Num return]),FILTER(ALL('Table (2)'),[Date]=_max))

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.