Reply
Pandetbaby
Frequent Visitor
Partially syndicated - Outbound

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?

 

IDOccurenceTotal Occurence for ID

A

13
B 0
C12
C12

A

13

A

13

A

 3

 

Thank you!

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

Syndicated - Outbound

@Pandetbaby 

Pls try

Column = CALCULATE(SUM('Table (3)'[Occurence]),ALLEXCEPT('Table (3)','Table (3)'[ID]))+0

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Syndicated - Outbound

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

ryan_mayu
Super User
Super User

Syndicated - Outbound

@Pandetbaby 

Pls try

Column = CALCULATE(SUM('Table (3)'[Occurence]),ALLEXCEPT('Table (3)','Table (3)'[ID]))+0

1.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)