Forum Discussion
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 | 20 | 90 | 28 |
| A | 155 | 30 | 90 | 30 |
| 390 | 148 | |||
| Report Matrix | Plant | Total Sales Order Qty | Total Delivery Qty | |
| A | 150 | 148 | ||
| How to subtotal a SalesOrder ID level ?? |
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!
3 Replies
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!
Yes I have, you can see this in the first list. The 2nd visual is a matrix, I need the subtotal of Sales Order Qty to behave correct. Total should be 150.
