FILTER function returns the table with the Filter condition that is applied for each of the source table rows. The FILTER function is not used for isolation and is used as a parameter to other functions like CALCULATE.
It is the iteration and can negatively affect the performance over large source tables. Complex filtering logic can be applied by referencing a measure in the filter expression.
