When filtering products in the Product Explorer the results only contain products that are listed on the first page, whether the page is showing 50 records per page or 1000 records per page. It does not reorder the products to include all records that meet the filtered criteria or let you switch between pages without clearing the filter. This leads to products that meet the criteria never being shown.
If you are using the small filters within the grid this is an issue. However if you use the “Quick Filter” tools we will filter across all products in your catalog. The grid filters are part of a control we use and only for the currently displayed list.