Archive for July, 2010

Avoid using FILTER on entire table in PowerPivot DAX


Kasper de Jonge has a nice blog item ( 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

Talking about Excel 2010 on SSAS 2008 R2 Named Set Creation

Categories: SQL Analysis Services