Matrix Table Filter issue

MP-iCONN,

Try this calculated column, which can be used as a matrix filter:

Work Order Status = 
VAR vWorkOrderID = Table1[Work Order ID]
VAR vNegativeRows =
    FILTER (
        Table1,
        Table1[Work Order ID] = vWorkOrderID
            && Table1[Available Comp] < 0
    )
VAR vResult =
    IF ( ISEMPTY ( vNegativeRows ), "OK", "SHORT" )
RETURN
    vResult

Hi MP-iCONN 

You can create a new column:

Column = VAR A=FILTER('Table','Table'[Work Order]=EARLIER('Table'[Work Order])&&'Table'[Available]<0)
RETURN IF(COUNTAX(A,[Work Order])>0,"Short","Ok")

Best Regards,

^{Yolo Zhu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}