DAX Functions - Filter

You can use DAX Filter functions to return specific data types, look up values in related tables and filter by related values. Lookup functions work by using tables and relationships between them. Filter functions enable you to manipulate data context to create dynamic calculations.

Following are the DAX Filter functions

• DAX ADDMISSINGITEMS function
• DAX ALL function
• DAX ALLEXCEPT function
• DAX ALLNOBLANKROW function
• DAX ALLSELECTED function
• DAX CALCULATE function
• DAX CALCULATETABLE function
• DAX CROSSFILTER function
• DAX DISTINCT function
• DAX EARLIER function
• DAX EARLIEST function
• DAX FILTER function
• DAX FILTERS function
• DAX HASONEFILTER function
• DAX HASONEVALUE function
• DAX ISCROSSFILTERED function
• DAX ISFILTERED function
• DAX KEEPFILTERS function
• DAX RELATED function
• DAX RELATEDTABLE function
• DAX USERELATIONSHIP function
• DAX VALUES function