If a table has more than one filter, you can select how to group the filters:

Filter All of filters the data with all of the filter criteria in the list (so that "and" is used between each filter).
Filter Any of filters the data with at least one of the filter criteria in the list (so that "or" is used between each filter).
Filter Add Group adds a new group in which multiple criteria can be added.
Filter Add Criterion adds a new criterion, the same as clicking the green plus sign.
Filter None presents all of the data with no filtering.

So, if a table (for example, one based on the Album entity) has two criteria, Genre and Media Type, and you use the default Filter All of, then the data must meet both criteria to be included in the table.

You can also nest table filters in groups to control how they are applied.

To nest filters in groups

Click the arrow next to All of, and select Add Group. A new group of criteria appears, indented from the other criteria.
Drag any criterion that you have created into the new filter group, or click the Add criterion button to add a new one. The criteria appear indented to the level of the filter group.
Once you have added criteria to the group, you can change how the filter is applied by dropping down the All of menu and changing it to Any of, etc.

Reference

Table Filtering