retrieve rows with max value within a group based on date filter

// Assumptions:
// Apart from [Reserve Status] all other columns
// in the fact table T should be hidden. Let's 
// assume that the AsOfDateSlicer table that stores
// dates is DISCONNECTED from T.

[Total Reserve] =
var __asOfDate = SELECTEDVALUE( AsOfDateSlicer[Date] )
var __filter =
    CALCULATETABLE(
        ADDCOLUMNS(
            SUMMARIZE(            
                T,
                T[ClaimId],
                T[DamageID],
                T[LocationID]
            ),
            "@MaxSeq",
                CALCULATE( MAX( T[Seq #] ) )
        ),
        KEEPFILTERS( T[Reserve Status] = "approved" ),
        T[Reserve Date] <= __asOfDate
    )
var __result =
    CALCULATE(
        SUM( T[Reserve Value] ),
        treatas(
            __filter,
            T[ClaimId],
            T[DamageID],
            T[LocationID],
            T[Seq #]
        ),
        ALL( T )
    )
RETURN
    __result