Remove Row context without removing Filter Context

Hi Anonymous ,

Please, try the next measure:

latestDate =
VAR currStep = MAX ( T[Step] )
RETURN
    CALCULATE (
        MAX ( T[Date] ),
        FILTER ( ALLSELECTED ( T ), T[Step] = currStep )
    )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

Anonymous ,

You can try this measure instead:

count = 
VAR _t =
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE ( T, T[Step], T[Result], T[Build] ),
            "@check",
                VAR maxDatePerStep =
                    CALCULATE ( MAX ( T[Date] ), ALLEXCEPT ( T, T[Step], T[Build] ) )
                VAR maxDatePerResult =
                    CALCULATE ( MAX ( T[Date] ) )
                RETURN
                    maxDatePerStep = maxDatePerResult
        ),
        [@check] = TRUE ()
    )
RETURN
    COUNTROWS ( _t )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.