Forum Discussion
Dax column - Available Quantity Calculation not working
Hi EricPad ,
Thanks for the reply from Ashish_Mathur , please allow me to provide another insight:
You can create a measure.
Available = MAX(vw_OpenOrdersByItem[TotalQuantityOnHand]) - SUM(vw_OpenOrdersByItem[NetOnOrder])If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked perfectly! Thank you so much!
I tried something similar as a column but not a measure. Thank you again for your help!
Hi EricPad ,
Ashish_Mathur , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
Try setting the field to "don't summarize".
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
When I click to not summarize the available field for some reason the Net On Order field value changes to an incorrect value as well.
I think the Available field needs to be some type of sumx value where for a given item code the sum of the Net On Order is subtracted from the static (per item code) Total Quantity on hand but I haven't been able to get the syntax correct.