topic Re: Need to implement Join along with Filter in PowerBi in DAX Commands and Tips

Need to implement Join along with Filter in PowerBi

Anonymous — Thu, 11 Feb 2021 16:43:32 GMT

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.

Re: Need to implement Join along with Filter in PowerBi

Anonymous — Fri, 12 Feb 2021 05:54:02 GMT

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

Re: Need to implement Join along with Filter in PowerBi

Anonymous — Fri, 12 Feb 2021 10:28:37 GMT

Anonymous thanks for reply.

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

Re: Need to implement Join along with Filter in PowerBi

Anonymous — Fri, 12 Feb 2021 10:42:55 GMT

Hi Anonymous ,

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

-
Nirav