Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |