Forum Discussion
Shippable Inventory Dax & Matrix
Hello, I have a Power BI Report that is using 4 different tables (Order Backlog, Inventory, Incoming Shipments & Production) I am trying to leverage all 4 tables to see what amount of inventory to f...
nmoriello try this:
Shippable Qty Total =
SUMX (
VALUES ( productTable[Product] ),
VAR BacklogQty = [YTD Qty Total]
VAR OnHandQty = CALCULATE(SUM('Total On Hand Qty'[OnHandQty]))
VAR IncomingQty = CALCULATE(SUM('Total CZUB Shipments'[Qty]))
VAR ProductionQty = CALCULATE(SUM('Total Unit Production'[Calculated_Qty]))
VAR TotalAvailableQty = OnHandQty + IncomingQty + ProductionQty
RETURN
MIN(BacklogQty, TotalAvailableQty)
)
Hi Parry2k,
That unfortunetly didnt work, it doesnt look like its even calculating the row level correctly with the SUMX and VALUES.