Once you connected from Tableau to Database, Drag all required Tables onto work area then define the Proper Joins as per Business Requirement.
Then come to "Sheet 1".
Then drag all required fields onto either row shelf or columns shelf as per ypur BUZ req.
then drag [RoleID] onto filters shelf then select "0" only.
I think now you will get what ever you are looking for.
Thanks Kumar for trying to help a newbie, but I already tried that. In fact if you noticed I am looking for NOT IN, so I excluded 0. The problem is that users can have multiple roles so someone with a 0 may also have a 5 and thus that user is still included. That is why I had the sub query to only include Userid that were not in the list of Userid associated with role 0.
Any other thoughts? Areally sets an option?
The way I would approach this, and there is probably a better way, is to create a secondary data source with SELECT Role.UserID FROM ROLE and as a data source filter just include the 0.
I would then add a relationship from the main data source to the secondary datasource on UserID. From the secondary data source grab the UserID and use that as a filter and hit exclude.
What specifically is not working in your subquery?