Show total sum of rows into each row

[FelipePalomino]

Hey guys!

I need a new column where it sums each instance of eash person.

I have a table like this:

ID Number

1        5

2        3

3        4

1        2

1        3

2        1

And I need something like this:

ID | Number | Calculated Column

1         5                       10  

2         3                        4

3         4                        3

1         2                       10

1         3                       10

2         1                        4

The biggest problem is: there is another column where I have an exclusive identifier (it's used to relate to another table), for each  row, so differentes instances of the ID 1 have different identifiers. My final goal is to find how many different people have Calculated Column > 5.

Can anyone help me?

[amitchandak]

@FelipePalomino , try a new column like

SUMX(FILTER(TABLE, TABLE[ID] = EARLIER(TABLE[ID]),TABLE[Number]))

or a new measure

calculate(SUM(TABLE[Number]),allexcept(TABLE[ID] ))

[camargos88 · Accepted solution]

Hi @FelipePalomino ,

Try this code for a column:

CALCULATE(SUM(TABLE[Number]); FILTER(TABLE; TABLE[ID] = EARLIER(TABLE[ID]))

In your measure, count it as distinct id where this column is > 5.

[FelipePalomino]

Thanks!!

It worked just fine!

I have never used this "earlier" before, so you solved the problem and I learned something new. 🙂