Forum Discussion
Drop Down Filters with 2 data sets
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?
1 Reply
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
