Forum Discussion
Need Help Running Total Based on two columns
Hi
Thanks for the reply. I would just like to add-- This data is only for one day and shows the material stock in a plant. Every day it will get refreshed once in the morning that willl tell the user how many orders can be filled for that material and in which plant. Also shows the status which plant has stock available for that material and If we need to transfer or deliver the material from any other plant.
I still think my RunTotal should be based on Plant and Material and not on Order No.
Please advise.
Thanks
You could add a calculated column for the Plant and Material
Plant and Mat = Plant & Material
Measure
Run Total = CALCULATE(SUM(Qty Available) - SUM(Qty to be Delivered), FILTER(ALLEXCEPT(Order Number, Plant and Mat), Order Number <= MAX(Order Number) && Plant and Mat = MAX(Plant and Mat)))
These max forulas dont often work great when summarising data so it may work well in detial but the totals may not work. There are people much better at DAX who may have a better idea then this one