filter inside of other filter vs "and" vs "&&"

[ania_roh]

Hi,

Is any difference between puting a filter into other filter (picture 1), and using funcion "and" (picture 2), or using " &&" (picture 3). 

Is everything means the same?

Picture 1: 

Picture 2:

Picture 3:

Thank you a lot.

[AlB · Accepted solution]

@ania_roh 

2 and 3 are the same

1 will return the same result as 2 and 3 but the implementation is different and performance (speed, memory used) might also vary depending on the cardinality of the columns. Imagine there's only one row where Price - Cost > 10000. The second (outermost) filter will need to look only at one row.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers