Forum Discussion
Solved
Subtotaling at higher level
I'm trying to subtotal at the level of SalesOrderID , Plant SalesOrder ID Delivery ID Sales Order Qty Delivery Qty A 133 1 60 29 A 133 2 60 31 A 155 10 90 30 A 155...
Ok, I think you are looking for the total by sales order without delivery ID.
In that case, you can summarize this data and not include Delivery ID in the summary table.
Something like this:
New Table= SUMMARIZE(Tablename, Tablename[Plant], Tablename[SalesOrder ID], "Order QTY", MAX(Tablename[Sales Order Qty], "Delivery Qty", SUM(Tablename[Delivery Qty]))
https://learn.microsoft.com/en-us/dax/summarize-function-dax
Please consider accepting as solution if this resolves the issue- thanks!
