Add a filter for the whole view that checks username in both fields as not null, and set the operator to 'And'.

Add a filter for the whole view that checks username in both fields as not null, and set the operator to 'And'.

In your view under 'Filter Criteria' do the following:

1. Add user name with the first relationship and set the operator to 'is not empty (NULL).
2. Do the same for the second username field.
3. Click the dropdown arrow next to add for 'Filter Criteria'. Select And/OR, Rearrange and add an 'AND' operator between the two filter.
4. Hide the second username from display.

That way you can filter for users with both flags.