Why do i lose virtually all records in a query dataset when I apply a filter using the analysis tool

Summary: i am trying to pull a report listing all those who are on the Basic life insurance Benefits. When I apply a filter based on Participant Enrollment Status to omit those who 'backed out' i end up with too few records. Before i apply the filter I get a recor count of over 700, as soon as i apply the filter it drops to 76 records.

Content (please ensure you mask any confidential information):

I am constructing an analysis to determine who in my organization has Basic Life insurance benefits offered by the company I work for. i am working in the 'Benefits - Enrollments Real Time' subject area