Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey!
I have a list of IDs and occurences, and I was wondering if there is a way to add a calculated column that will give me the total set of occurences per ID?
ID | Occurence | Total Occurence for ID |
A | 1 | 3 |
B | 0 | |
C | 1 | 2 |
C | 1 | 2 |
A | 1 | 3 |
A | 1 | 3 |
A | 3 |
Thank you!
Solved! Go to Solution.
Pls try
Column = CALCULATE(SUM('Table (3)'[Occurence]),ALLEXCEPT('Table (3)','Table (3)'[ID]))+0
Proud to be a Super User!
Hi, @Pandetbaby
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution to close this thread.
Best Regards,
Community Support Team _ Eason
Pls try
Column = CALCULATE(SUM('Table (3)'[Occurence]),ALLEXCEPT('Table (3)','Table (3)'[ID]))+0
Proud to be a Super User!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |