Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wvanpeel
Advocate II
Advocate II

Subtotaling at higher level

I'm trying to subtotal at the level of SalesOrderID ,   

PlantSalesOrder IDDelivery IDSales Order QtyDelivery Qty
A13316029
A13326031
A155109030
A155209028
A155309030
   390148
Report MatrixPlantTotal Sales Order QtyTotal Delivery Qty 
 A150148 
     
  How to subtotal a SalesOrder ID level ??  
1 ACCEPTED SOLUTION
djurecicK2
Super User
Super User

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!

View solution in original post

3 REPLIES 3
djurecicK2
Super User
Super User

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
Super User
Super User

Hi @wvanpeel ,

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

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.