Subtotaling at higher level

[wvanpeel]

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 ??

[djurecicK2 · Accepted solution]

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!

[djurecicK2]

Hi @wvanpeel ,

 Have you tried putting the SalesOrder ID field into your visual?

[wvanpeel]

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.