If you go to the filter menu (little down arrow next to the title) and select "Only relevant values", that filter will return only values that are in the worksheet. Therefore if you add your active/inactive dimension to the filter shelf first and set to active, your subsequent user filter should only show users that are active.
Hope that helps
You could put the Inactive/Active field on the filter shelf and filter out the inactives. Set up the Names filter to 'only show relevant values'.
However this would mean all of the inactive users are removed from the view, which you may not want.
Therefore you may be better to create a calculated field to act as your filter:
If [ActiveField] = 1 THEN [Name] ELSE 'zzInactiveUser' END
This will show the names of all active users and put the inactive users into a group that would appear at the bottom of the list of users in the filter. This field would go on the filters shelf rather than the Name field.
When I right click on the filter I don't get the "Only Relevant values" option. I thought I read somewhere that this option is NOT available if you are going against a data source that resides on a Tableau server.
I've used that feature against data sources published to tableau server, do you have a similar situation to the person in this thread? i.e. blended datasources and you're trying to filter using the secondary data source?
Steve - Thanks for the heads up. That looks like it might just be my problem. I'll give it a try.