cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_BTG Frequent Visitor
Frequent Visitor

Count the number of times a value appears in a table

I've read many posts for similar questions, but none apply to my scenario...

 

I have an Employee Table and a Project Team table that are connected by the Employee ID number.

 

I want to show how many projects each employee has been on, by counting the number of times each ID appears in the table.

 

Here is a mock-up of my Project Team table:

 

Sample Table for PBI Forum.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

Here is what my outpout would look like:

 

Sample Result for PBI Forum.JPG

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count the number of times a value appears in a table

Hi @Rob_BTG ,

 

Believe that the fastest wau would be to unpivot your Project Team Table and stay with only 3 columns Project ID, Team Member, Employee ID then just make a simple count of the number of ID.

 

Regards,

MFelix



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

Proud to be a Datanaut!




2 REPLIES 2
Super User
Super User

Re: Count the number of times a value appears in a table

Hi @Rob_BTG ,

 

Believe that the fastest wau would be to unpivot your Project Team Table and stay with only 3 columns Project ID, Team Member, Employee ID then just make a simple count of the number of ID.

 

Regards,

MFelix



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

Proud to be a Datanaut!




Rob_BTG Frequent Visitor
Frequent Visitor

Re: Count the number of times a value appears in a table

MFelix,

 

Thanks, that would be the simplest way.  I was making it harder than it needed to be.