Forum Discussion

wvanpeel's avatar
wvanpeel
Icon for Advocate II rankAdvocate II
3 years ago
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...
Need Help
  • djurecic's avatar
    djurecic
    3 years ago

    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!

djurecic's avatar
djurecic
Icon for Super User rankSuper User
3 years ago

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!