Create column that sums all values with the same ID

Question

Hello!I have a table that follows this structure:IDValueA3A5B2C7D9D2D11E5I 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&nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp;SUM_ValueByIdA38A58B22C77D922D222D1122E55How can I do this?

farhanjeelani · Accepted Answer

Hi&nbsp;nok&nbsp;&nbsp;,
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.

Forum Discussion

Create column that sums all values with the same ID

DAX Formula:

2 Replies

DAX Formula:

Related content

Create columns group

Create measure to return value from column when condition met for two other columns

Splitting Column values

Matching Column Values

Update column value without creating new column

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

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

Forum Discussion

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

DAX Formula:

DAX Formula:

Create columns group

Create measure to return value from column when condition met for two other columns

Splitting Column values

Matching Column Values

Update column value without creating new column

Create column that sums all values with the same ID