According to the PowerPivot Help for SQL Server 2008R2, the DAX FILTER() function ???returns a table that represents a subset of another table or expression.??? FILTER() is a member of the Filter Functions group, which is composed of fourteen functions that specifically support certain advanced types of analysis.