Measure to filter all filters/slicers

[Pbiuserr]

Hello,

Ive been watching a set of videos where you could filter the slicer by using measure. My problem is - most often they did use SalesAmount which is not available in my report and the columns are used in various kind of measures

I have few filters (LETS asumme tables have same names)

Employee Category

Department

Job Title

and I want one to filter each other, so If I select Job Title = "Helpdesk" then I'd have a Departments only having this job title (I assume it would be "IT") and Employee Category would be something like Technican.

If I click at department = "Payroll" then I have Employee Category something like "Operations", "Managers", "Directors" and Job Titles like "Payroll Analyst" and other Payroll titles

The point is I don't know what measure to do.. like = INT ( ISEMPTY ( Fact Table )  ) (because all are connected to fact table?) or
INT ( ISEMPTY ( Employee Category )  ) ||  INT ( ISEMPTY ( Department )  ) || INT ( ISEMPTY ( Job Title )  ) and having greater than 0 in filter?

Thank you in advance for your help

[PaulDBrown]

Create a measure along the lines of:

Filter slicers =
COUNTROWS ( RELATEDTABLE ( 'Fact Table' ) )

Add the measure as a filter for each slicer and set the value to greater or equal to 1