Filtered table as filter argument (multiple columns predicate with OR condition over ALL table rows)
A FILTER function filtering ALL the rows of an entire table using an OR condition on multiple columns is used as a filter argument in functions such as CALCULATE, CALCULATETABLE, etc.
Remarks
Because the conditions are applied with an || operator, the multiple columns predicate must be kept in a single filter argument, without filtering an entire table.
In order to keep the same semantics as the original filter, apply REMOVEFILTERS on the previously iterated table because the iterator was over ALL of that table.
Recommended articles:
Example
Replace the Customer iterator with a REMOVEFILTERS over Customer, and move the condition into a single filter argument, so the filter is applied only to the Customer[Country] and Customer[Age] columns instead of filtering the entire Customer table.
Original code
CALCULATE (
[Sales Amount],
FILTER (
ALL ( Customer ),
Customer[Country] = "Canada"
|| Customer[Age] >= 21
)
)
Possible optimization
CALCULATE (
[Sales Amount],
REMOVEFILTERS ( Customer ),
Customer[Country] = "Canada"
|| Customer[Age] >= 21
)