Create column that sums all values ​​with the same ID

[nok]

Hello!

I have a table that follows this structure:

ID	Value
A	3
A	5
B	2
C	7
D	9
D	2
D	11
E	5

I want to create a new column that will sum the value of the "Value" column for all the same IDs.

The expected result would be something like this:

ID	Value	SUM_ValueById
A	3	8
A	5	8
B	2	2
C	7	7
D	9	22
D	2	22
D	11	22
E	5	5

How can I do this?

[FarhanJeelani · Accepted solution]

Hi @nok  ,

You can achieve this by creating a calculated column in Power BI using DAX.

DAX Formula:

SUM_ValueById = CALCULATE( SUM('Table'[Value]), FILTER('Table', 'Table'[ID] = EARLIER('Table'[ID])) )

Please mark this as solution if it helps you. Appreciate Kudos.

[rsbin]

@nok ,

Your Calculated Column is:

SumID = CALCULATE( SUM([Value]),

           ALLEXCEPT( 'Table', 'Table'[ID] ))

Regards,