Drop Down Filters with 2 data sets

[Rania_Ibrahim]

Hello,

I'm currently using two data sets that I've created a relationship table for further analysis. But I was struggling that when the end user filters on a specific department all the options in the job category to them.

In the below example, if the end user filters on Tax he / she shall only see PSS , CSS only and not the 3 options as per the below. Is there a way to restrict all list from appearing when I filter on a specific department? 

[amitchandak]

@Rania_Ibrahim , if there table are joined to each other or have common fact. Create a meausre on many side table 

say

countrows(Table)

and use that in the visual level filter and check for nonblank

https://www.youtube.com/watch?v=cyOquvfhzNM