Forum Discussion
Filtering only particular columns based on a filter selection
I have two data sources: One with a list of employees, and one with a list of classes and those who participated. Ive created a measure and visual to show which % of each region has completed the co...
Hi Anonymous ,
Can you pls share some sample data and the expected output.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
In case it did not help, please provide additional information and mark me with @ so that I can investigate further
Source Data Table 1:
| Manager | Employee |
| Bill | Tom |
| Bill | Bob |
| Bill | Mark |
Source data table 2:
| Course | Employee | Status |
| A | Tom | Completed |
| A | Bob | Completed |
| A | Brian | Completed |
| B | Tom | Completed |
What I want to create:
Slicer: Course A
| Manager | Employee | Status |
| Bill | Tom | Completed |
| Bill | Bob | Completed |
| Bill | Mark | (blank or Incomplete) |
The problem:
Because Mark did not complete the course, he is not in table 2. Therefore, when I filter my final output by a specific course, he disappears instead of lets me have an incomplete status