Column with sum of distinct values

[estt]

Hello, i need help to make a column that sum the numbers in the column tp_kmro, based on the column id_pref. In the column id_pref i have the id and this id repeats lots of times ex:

id_pref	tp_kmro
1	2
1	2
1	2
2	4
2	4
3	5

i made a column based on id_pref with distinct values so the new id_pref is now:

1

2

3

Now i need to make a new column tp_kmro with the sum of all values in this column

example: sum all values in tp_kmro and put next to id_pref .

like this:

id_pref	tp_kmro
1	6 (2+2+2)
2	8 (4+4)
3	5 (5)

Can someone help with this please?

[estt]

Thanks, it worked!

[Fowmy]

@estt 

Create the below measure and use it in a Table Visual along with your id_pref column

Total = sum(tablename[tp_kmro])

[estt]

It worked man thanks, but i need to make this column in power query.

[Fowmy · Accepted solution]

@estt 

Right click on the id_pref, select Group By