Forum Discussion

nmoriello's avatar
nmoriello
Frequent Visitor
1 year ago

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...
Need Help
parry2k's avatar
parry2k
Super User
1 year ago

nmoriello try this, if not It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

 

 


Shippable Qty Total =
SUMX ( 
   ProductTable,
   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)
)