Firstnonblank rows based on another column per group

Anonymous,

Try these measures:

iscomplained calc =
VAR vCurrentStatus =
    MAX ( Table2[status] )
VAR vValueBlankStatus =
    CALCULATE (
        MAX ( Table2[iscomplained] ),
        ALLSELECTED ( Table2 ),
        VALUES ( Table2[customerno] ),
        Table2[status] = BLANK ()
    )
VAR vMinStatusDate =
    CALCULATE (
        MIN ( Table2[status date] ),
        ALLSELECTED ( Table2 ),
        VALUES ( Table2[customerno] ),
        NOT Table2[status] = BLANK ()
    )
VAR vMinStatus =
    CALCULATE (
        MIN ( Table2[status] ),
        ALLSELECTED ( Table2 ),
        VALUES ( Table2[customerno] ),
        Table2[status date] = vMinStatusDate
    )
VAR vResult =
    SWITCH (
        TRUE (),
        ISBLANK ( vCurrentStatus ), BLANK (),
        IF (
            NOT ISBLANK ( vValueBlankStatus )
                && vCurrentStatus = vMinStatus,
            vValueBlankStatus,
            MAX ( Table2[iscomplained] )
        )
    )
RETURN
    vResult

iscomplained final = 
SUMX ( VALUES ( Table2[customerno] ), [iscomplained calc] )