Formula Help

Here is a column you can put on your orders table to indicate if there is sufficient inventory for each item.  It also works as a measure expression that will work in a table visual with the Order # column.

Enough =
IF (
    ISBLANK (
        CALCULATE (
            COUNT ( Orders[Order #] ),
            FILTER (
                ALLEXCEPT (
                    Orders,
                    Orders[Order #]
                ),
                Orders[Inventory] < Orders[Items Needed]
            )
        )
    ),
    "Y",
    "N"
)

Regards,

Pat