topic Re: Filtering only particular columns based on a filter selection in DAX Commands and Tips

Filtering only particular columns based on a filter selection

Anonymous — Sun, 26 Apr 2020 13:01:55 GMT

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 course selected from a table visual / filter, but on the bottom of my page, I want to have a list of all the employees (which ive grouped by manager already in a matrix), and their "status" of whether or not they attended the course.

However, when I filter on a particular course, it filters the whole table, so all I get is a list of employees who have attended the course, filtering out those who have not.

How do I keep both those who have and those who haven't attended the course in the list, but show the status of whether or not they attended, without filtering the table from the course selected?

Re: Filtering only particular columns based on a filter selection

Anonymous — Sun, 26 Apr 2020 13:24:04 GMT

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

Re: Filtering only particular columns based on a filter selection

Anonymous — Sun, 26 Apr 2020 14:07:25 GMT

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