Grouped sums of column values

[sigridr]

Hello, 

I have a table with values between 1-5 and ID numbers. 

Something like the table below. 

How do I find (/create a column or a table?) with the sums of values grouped by ID? 

ID	Value
14	3
14	2
14	5
14	1
27	5
27	5
27	5
27	4
39	3
39	4
39	4
39	3

How do I find (/create a column or a table?) with the sums of values grouped by ID? 

So like this: 

ID	Sum
14	11
27	19
39	14

[amitchandak · Accepted solution]

@sigridr , Pu them in a visual ID ( Don't Summarize) and value as SUm or use measure

sum(Table[Value])

If you need new table, Power Query group by

https://docs.microsoft.com/en-us/power-query/group-by

Dax

new table = summarize(table, Table[ID], "Sum", sum(Table[Value]) )