Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!!!!!!
Solved! Go to Solution.
Hi:
You can use this calculated column. I used "table" for table name - you would swop in your table name.
If you are satisified with reply, can you mark as solution? Thanks
Hi @Anonymous
you may try
SUMX (
CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[division] ) ), Table[counts] )
Hi @Anonymous
you may try
SUMX (
CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[division] ) ), Table[counts] )
Hi:
You can use this calculated column. I used "table" for table name - you would swop in your table name.
If you are satisified with reply, can you mark as solution? Thanks
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |