The FILTER function returns a table with a filter condition applied for each of its source table rows. The FILTER function is rarely used in isolation, it’s generally used as a parameter to other functions such as CALCULATE.
* FILTER is an iterator and thus can negatively impact performance over large source tables.
* Complex filtering logic can be applied such as referencing a measure in a filter expression.
FILTER(MyTable,[SalesMetric] > 500)
Posted Date:- 2021-09-26 22:45:41