Return largest value

Not sure if you wanted a column or a measure expression, but here is a column expression that gets your desired results.

Display Offer =
VAR thisoffer = Sheet1[Total IIN]
VAR maxoffer =
    CALCULATE (
        MAX ( Sheet1[Total IIN] ),
        ALLEXCEPT (
            Sheet1,
            Sheet1[Property]
        ),
        Sheet1[Offer Status] = "Pending"
    )
RETURN
    IF (
        AND (
            thisoffer = maxoffer,
            Sheet1[Offer Status] = "Pending"
        ),
        thisoffer,
        0
    )

Regards,

Pat