Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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 |
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
10 | |
8 | |
5 | |
5 | |
4 |