topic Re: SUMX in one colomn in DAX Commands and Tips

SUMX in one colomn

dofrancis3 — Fri, 22 Nov 2024 14:02:28 GMT

Dear Team

I need your support i would to as per data set below i would like to have the results belown: (you cans use: SUMX or...)

Raw data

Val
0
0
1
0
1
1
0
1
1
1
1

Re: SUMX in one colomn

Prasanthke — Fri, 22 Nov 2024 14:59:08 GMT

please explain your question clearly

Re: SUMX in one colomn

dofrancis3 — Fri, 22 Nov 2024 15:47:57 GMT

FreemanZ , Jihwan_Kim , lbendlin, Prasanthke , shafiz_p ibendlin In my data set i have this colomn:

So i need to have the result below (table):

How can i do it?

Re: SUMX in one colomn

lbendlin — Fri, 22 Nov 2024 16:48:58 GMT

Group by val and add a sum aggregation

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlCK1YGRhhhsXCJwMhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Val = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Val", Int64.Type}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"Val"}, {{"val", each List.Sum([Val]), type nullable text}}), #"Removed Other Columns" = Table.SelectColumns(#"Grouped Rows",{"val"}) in #"Removed Other Columns"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the entire Source step with your own source.