Forum Discussion
Solved
Calculated column - counting occurrences associated with unique IDs
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 Occuren...
Pls try
Column = CALCULATE(SUM('Table (3)'[Occurence]),ALLEXCEPT('Table (3)','Table (3)'[ID]))+0
ryan_mayu
Super User
Super UserPls try
Column = CALCULATE(SUM('Table (3)'[Occurence]),ALLEXCEPT('Table (3)','Table (3)'[ID]))+0