DAX command to Status a column based on filtered Rows and IF statements

Hi,

try:

Outcome = 
    VAR ScriptOutcomes =
        CALCULATETABLE(
            VALUES(TableTests[Test Outcome]),
            FILTER(
                ALL(TableTests),
                TableTests[Script ID] = EARLIER(TableTests[Script ID])
            )
        )
    
    VAR hasPassed = CONTAINSROW(ScriptOutcomes, "Passed")
    VAR hasFailed = CONTAINSROW(ScriptOutcomes, "Failed")
    VAR isBlocked = CONTAINSROW(ScriptOutcomes, "Blocked")

    RETURN 
        IF(
            isBlocked,
            "Blocked",
            IF(
                hasFailed,
                "Failed",
                IF
                    (hasPassed,
                    "Passed",
                    "N/A"
                )
            )
        )