In many cases it is useful to have a filter where a row filtering should depend on two columns.
An example would be to select all rows with country equal to UK or Year before 2010.
This is currently not possible without using a calculated column which is less flexible.
I think there are two concerns here:
You can create more complex filter conditions by inserting a calculated column with a logical expression. E.g. if you add a column with the following expression ([Department]="Finance") Or ([Employee Status]="Contractor") you will get a filter with the values true or false that allow you to filter out or filter in all rows that satisfies your condition.
It´s also possible to limit what is shown in a specific visualization by using a logical expression similar to the one above.
Yes this would be nice and it would be great to be able to switch between AND and OR. Users sometimes want to see when all filter conditions are true rather than if any are true.
I'd love to have this. So many times we need to filter out only a specific combination (e.g. filter out device 4 but only on board 2)