George's BI Blog

Kasper de Jonge has a nice blog item (http://www.powerpivotblog.nl/tune-your-powerpivot-dax-query-dont-use-the-entire-table-in-a-filter-and-replace-sumx-if-possible) showing that using FILTER function on an entite table has performance issue. As FILTER will create a copy of the entire table in the memory, it is a very expensive function in DAX.

Using VALUEs(<Column>) if you are going to filter based on an indivudual column. Rather than FILTER, VALUES creates a one-column table which doesn’t contain duplicated value (think it as Distinct in T-SQL).