Check if quantity equals in rows with same id

Hi dshmulenson ,

Please try below steps:

1. below is my test table

Table:

2. create a new column with below dax formula

IsQuantityEqualForAvailableStatus =
VAR currentItemID = 'Table'[Item ID]
VAR currentQuantity = 'Table'[Quantity]
VAR availableItemsSameID =
    FILTER (
        ALL ( 'Table' ),
        'Table'[Item ID] = currentItemID
            && 'Table'[Status] = "available"
    )
RETURN
    IF (
        COUNTROWS ( availableItemsSameID ) > 1
            && CALCULATE ( MIN ( 'Table'[Quantity] ), availableItemsSameID ) = currentQuantity
            && CALCULATE ( MAX ( 'Table'[Quantity] ), availableItemsSameID ) = currentQuantity,
        "Yes",
        "No"
    )

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.