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 TimeEnteries

 

EmployeeList:

EmployeeName, EmployeeEmail

 

TimeEnteries

EmployeeEmail, WeekOf, Status

 

I want a list like below:

Please help me with this.

 

 

COUNT
Filter
join
Measures
Table

3 Replies

  • 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