Filter out records on a list based on another filter

[ezequiel]

Hi.

I have a list of employees and I want to exclude from the list those that are displayed on the result of a filter. Example:

Complete list has Employee A, Employee B, Employee C and Employee D. The result of the filter is Employe A, Employee B. I want a second list that shows only Employee C and Employee D.

Is there any way to show the "complement" of the whole list?

Thanks

Ezequiel

[v-yalanwu-msft · Accepted solution]

Hi, @ezequiel ;

You could create another table as slicer without relationship .

1.create a table as slicer.

slicer = VALUES('Table'[Employee])

2.create a flag measure.

flag = IF(MAX([Employee]) in ALLSELECTED('slicer'[Employee]),1,0)

3. apply the measure into visual filter.

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.