Need to implement Join along with Filter in PowerBi

[Anonymous]

I am creating a report for a Timesheet application where I need to show list/count of employees who has either not submitted their timesheet or even not initiated.

I have two tables EmployeeList and TimeEnteries

EmployeeList:

EmployeeName, EmployeeEmail

TimeEnteries

EmployeeEmail, WeekOf, Status

I want a list like below:

Please help me with this.

[Anonymous]

Hey @Anonymous 

Mapp both table with EmployeeName.
Use status column in filter section and hide it.
So it will displayed filtered value as per pre-filtered value set..

Best Regards,
Nirav

[Anonymous]

@Anonymous thanks for reply.

I tried this but its not working, as I need to show the count also in Matrix

[Anonymous]

Hi @Anonymous ,

For matrix, EmployeeEmail column selected from EmployeeList table? or 
can you share sample .pbix file.

-
Nirav