How to do a sum of a column based on values of another column

[Anonymous]

I've seen several other posts similar to this, but the proposed solutions don't quite work for this.   Here's some sample data

division	counts
ABC	23
123	18
EVEN	156
ODD	86
ABC	2
123	0
ABC	11
123	2884
ABC	1236
123	12
EVEN	7
ODD	354
ABC	76
123	3
EVEN	764
ODD	3
ODD	4

I need to add a column that has the summation of counts for each division.  Assume an infinite number of divisions,  assume any integer in the counts column, assume the data isn't sorted, and assume that there can be any number of entries for a division.   Lot's of assumptions, no?

  Ideally, the output would look like this

division	counts	division totals
ABC	23	1348
123	18	2917
EVEN	156	927
ODD	86	447
ABC	2	1348
123	0	2917
ABC	11	1348
123	2884	2917
ABC	1236	1348
123	12	2917
EVEN	7	927
ODD	354	447
ABC	76	1348
123	3	2917
EVEN	764	927
ODD	3	447
ODD	4	447

note the repeats in the division totals column...

Please and thank you!!!!!!!

[Whitewater100 · Accepted solution]

Hi:

You can use this calculated column. I used "table" for table name - you would swop in your table name.

Sum of Divison = Calculate(Sum('Table'[counts]),

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

If you are satisified with reply, can you mark as solution? Thanks

[tamerj1 · Accepted solution]

Hi @Anonymous 

you may try

SUMX (

CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[division] ) ), Table[counts] )

[Whitewater100 · Accepted solution]

Hi:

You can use this calculated column. I used "table" for table name - you would swop in your table name.

Sum of Divison = Calculate(Sum('Table'[counts]),

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

If you are satisified with reply, can you mark as solution? Thanks