New Table sum column based on distinct values in a column

[blopezpr]

I want to create a new table that brings a Distinct Value from a Column and them sum other columns based on that unci value:

Example:

Table A in Data Model:

ID	Paid
AA	100
AA	200
AA	300
BB	25
BB	100
BB	25
CC	20
CC	25
CC	5

New Table:

ID	Paid
AA	600
BB	150
CC	50

[ERD · Accepted solution]

Hello @blopezpr ,

Here is one of the ways to achieve this:

New table = 
ADDCOLUMNS (
    VALUES ( 'Table'[ID] ),
    "Sum", CALCULATE ( SUM ( 'Table'[Paid] ) )
)

Did I answer your question? Mark my post as a solution!