Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need to implement Join along with Filter in PowerBi

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...
COUNT
Filter
join
Measures
Table
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

Anonymous thanks for reply.

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

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

    -
    Nirav