DAX Conditional Lookup According to ID Column

Hi,

Based on the above condition, I tried to create a calculated column like below.

Please check the below picture and the attached pbix file.

New_Status CC =
VAR _referencecolumn =
    SUMMARIZE (
        FILTER ( Data, Data[Order ID] = EARLIER ( Data[Order ID] ) ),
        Data[Shipping  Status]
    )
RETURN
    SWITCH (
        TRUE (),
        "Delivered"
            IN _referencecolumn
            && "Not Started"
            IN _referencecolumn
            && "Shipped" IN _referencecolumn, "Not Started",
        "Delivered"
            IN _referencecolumn
            && "Shipped" IN _referencecolumn, "Shipped",
        "Delivered" IN _referencecolumn, "Delivered",
        "Not Started" IN _referencecolumn, "Not Started"
    )