Forum Discussion

A7T57ZZ's avatar
A7T57ZZ
Frequent Visitor
3 years ago
Solved

Combine Rows for Single Order in DAX

I am trying to combine rows with the same in DAX for a visual.  Right now the DB is showing this as two or multiple different lines based on quantity status.  The top chart shows how it looks current...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    A7T57ZZ Seems like a simple Group By:

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjU1MLcwBBLmhgZKOkogbGlgoBSrg1XK0Ai7nImFAYjCpc0MpCsWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"SO - Doc & Line" = _t, #"Line Item Qty" = _t, #"OBD Line Item Qty" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"SO - Doc & Line", Int64.Type}, {"Line Item Qty", Int64.Type}, {"OBD Line Item Qty", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"SO - Doc & Line"}, {{"Line Item QTY", each List.Sum([Line Item Qty]), type nullable number}, {"OBD Line Item Qty", each List.Sum([OBD Line Item Qty]), type nullable number}})
in
    #"Grouped Rows"

    Or in DAX:

    Table = SUMMARIZE('Table'[SO - Doc & Line],"Line Item Qty",SUM([Line Item Qty]),"OBD Line Item Qty",SUM([OBD Line Item Qty]))

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

A7T57ZZ 

That doesn't change anything. Still don't understand why you cannot summarize the columns by sum? Or just create a simple SUM measures?

A7T57ZZ's avatar
A7T57ZZ
Frequent Visitor
3 years ago

You are correct, I used a simple summarize.  I was overcomplicating things trying to account for other columns that contain uniuque values.  Going to use MAX/MIN or COUNT to take care of that issue for my purpose.  Your response is greatly appreciated!