When adding filter in columns, rows that don’t fit the filter condition will be hidden.

Then user can choose Worksheet: Reduce Rows...

Choose Reduce Method: Delete Hidden Rows to remove those rows.

Edit: Undo is supported.