How to SUM values when a column is equal in a table, SUM per row, like SUMX does.

[gluizqueiroz]

I have the following table:

Index	Region	Profit
1	North	100
2	South	200
2	Southeast	50
3	East	350
4	West	450
5	Northeast	150
5	Southeast	250

I need to create a calculated column that SUM the column Profit when column Index is equal, like the following example:

Index	Region	Profit	Calculated
1	North	100	100
2	South	200	250
2	Southeast	50	250
3	East	350	350
4	West	450	450
5	Northeast	150	400
5	Southeast	250	400

I tried CALCULTE and SUMX but I received some errors.

[parry2k · Accepted solution]

@gluizqueiroz add a measure

sum = CALCULATE( SUM( Table6[Profit] ), ALLEXCEPT( Table6, Table6[Index] ) )