IF SUM Statement DAX

mbbui0721,

Try this calculated column. I'm not sure if you want "Pending" for every row that is not "Fulfilled", or for every row that is not "Fulfilled" and TYPE = "Work Order Warranty" or "Warranty Transaction". The DAX can be easily adjusted to accommodate either scenario.

Status = 
VAR vWorkOrderWarranty =
    CALCULATE (
        SUM ( Table1[QTY] ),
        ALLEXCEPT ( Table1, Table1[Item] ),
        Table1[TYPE] = "Work Order Warranty"
    )
VAR vWarrantyTransaction =
    CALCULATE (
        SUM ( Table1[QTY] ),
        ALLEXCEPT ( Table1, Table1[Item] ),
        Table1[TYPE] = "Warranty Transaction"
    )
VAR vResult =
    SWITCH (
        TRUE (),
        Table1[TYPE]
            IN { "Work Order Warranty", "Warranty Transaction" }
            && vWorkOrderWarranty > vWarrantyTransaction, "Fulfilled",
        Table1[TYPE]
            IN { "Work Order Warranty", "Warranty Transaction" }
            && vWorkOrderWarranty <= vWarrantyTransaction, "Pending"
    )
RETURN
    vResult