Formula Help

Kareus — Sat, 07 Nov 2020 22:20:44 GMT

How can I determine if all the rows that share a particular order # have inventory to ship Order #400001 complete.

Report Date	Order #	Scheduled Date	Description	Inventory	Items Needed	Is Their Enough Inventory On Hand To Ship Order Complete	WHICH ORDER NUMBERS
11/7/2020	400000	11/7/2020	Widget #1	1000	25	YES
11/7/2020	400001	11/7/2020	Widget #1	1000	20	YES
11/7/2020	400001	11/7/2020	Widget #2	2	4	FALSE
11/7/2020	400001	11/7/2020	Widget #3	55	11	YES
11/7/2020	400002	11/7/2020	Widget #3	55	13	YES

Re: Formula Help

mahoneypat — Sun, 08 Nov 2020 01:00:39 GMT

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

topic Formula Help in DAX Commands and Tips

Formula Help

Re: Formula Help