Total in every row in Table

[RsimonAlign]

Hi ,

I Have Table Like :

Account	Quantity
1	20
1	40
2	12
2	18
3	70

I want to add column like This: 

Account	Quantity	New Column
1	20	60
1	50	60
2	12	30
2	18	30
3	70	70

[Anonymous · Accepted solution]

Hi  @RsimonAlign ,

Here are the steps you can follow：

1. Create calculated column.

New Column =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Account]=EARLIER('Table'[Account])),[Quantity])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly