Hide values in a slicer when there is no data in a different table

[Grella]

I've searched through the threads and haven't come across exactly what i'm after, or perhaps i'm not understanding the solutions clearly to be able to apply to my scenario.

Among other tables, I have an employee table and a sales table with sales data from 2019 onwards. The employee table contains thousands of employees some of which have left the company prior to 2019 hence wouldn't have any sales. When i add a slicer using EmpID from the Employee Details table, i don't want to see EmpIDs of those that i know have left and wouldn't have any sales values against their name. 

Note as there are thousands of employees in the employee table, i'd be looking at removing about 60% of them from the slicer drop down so am looking for the easiest way to do this. Can i use a measure to apply as a filter?

What i have now:

What i want to have:

Sample File - Hide slicer values.pbix

Thanks in advance for any help!

[DataInsights]

@Grella,

This article explains how to use a measure as a visual filter for slicers:

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/ 

[andy808]

I am trying to apply:

Slicer_Manager =

    INT (

        NOT ISEMPTY ( Hire )

        ||

        NOT ISEMPTY ( Vacancy )

    )

however I am using a bridge table between 2 tables (Hire and Vacancy) and the bridge table has [Manager] field in it and I use this field in Manager Slicer. I do not want a mangers name to appear in the slicer IF the manager has no data on either the Hire or Vacancy table. 

Appreciate any help here!

Dawn