topic Looking for Table in DAX in DAX Commands and Tips

Looking for Table in DAX

Whitewater100 — Sat, 28 Oct 2023 23:40:21 GMT

Remaining Inventory after Finalized orders Subtracted

Hello Community:

I have created a table using some basic measures, see attached. I am looking for suggestions on how to write DAX as a table function for my main visual. Inventory is stored in multiple locations and orders in this case are subtracted from inventory if they are noted as finalized.

I have the main visual which I'm looking to produce as a DAX table function.

Thank you!

Re: Looking for Table in DAX

Whitewater100 — Sun, 29 Oct 2023 13:10:59 GMT

Please find link to report. Sorry it was not shared correctly the first time!

https://drive.google.com/file/d/1VQurjakljRyT1x9bBtHzFF_UjsDw3xbY/view?usp=sharing

Re: Looking for Table in DAX

Dangar332 — Sun, 29 Oct 2023 19:09:09 GMT

Hi, Whitewater100

new Table = SUMMARIZECOLUMNS(Products[Product],WH_Loc[WH_Area],WH_Name[WH Name], "total wh qty",SUM(WH_Inv[WH_Qty]), "finalized order qty", CALCULATE(SUM(Orders[Order Qty]),Orders[Order Status]="finalized"), "balance of INV(oh-final oq)",SUM(WH_Inv[WH_Qty])-CALCULATE(SUM(Orders[Order Qty]),Orders[Order Status]="finalized") )

Re: Looking for Table in DAX

Whitewater100 — Sun, 29 Oct 2023 22:45:05 GMT

Thanks very much! Nice job:-)