Archive
Archive for the ‘PowerPivot’ Category
Avoid using FILTER on entire table in PowerPivot DAX
July 16, 2010
Leave a comment
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).
Categories: PowerPivot