Need to count the number of times a name appears in a column based on a separate list of names.

[Nightfalcon17]

I am working with a dataset that has various tasks that need to be completed on a single invoice. I need to create a pivot table that counts the number of times each employee's name shows under each task. However the data set has names of people (i.e. Erin) that I don't need to include in the pivot table. The only names I need in the pivot table are shown under the "employee" table (a.k.a. Table 2). I'm trying to make this sheet easy to work with so as new employees come along we can simply add their name to the "employee list"  and it will add them into the pivot table. 

I have tried countrows, counta, and other various measures in my data model but have not been able to get it to work yet. With not being able to create relationships between the two tables it is makeing it difficult to filter how I need it to show.  The closest I can get only takes one column's data into account and the will then duplicate that into the next columns reguardless of the field I select to be in the next column. 

Here is a screenshot of a sample data sheet I put together to illustrate the problems I am having.  I have also created a manual caluclation at the bottom to illistrate how I would like the data to show.  

[Nightfalcon17]

I completly forgot about unpivot option. That got me what I needed. Thank you so much for your help!

[Ajendra · Accepted solution]

Hey pls check below:-

Select last three columns and "Unpivot" them only in Power-Query (Select them at the same time and Use Right Click).

Then Insert a Matrix Table and place field into that as shown below.

At the last try to create this measure and place that measure into the Matrix table.

I hope i got your question correctly and answered. Thanks!!