Filter functions

The filter and value functions in DAX are some of the most complex and powerful, and differ greatly from Excel functions. The lookup functions work by using tables and relationships, like a database. The filtering functions let you manipulate data context to create dynamic calculations.

In this section

ADDMISSINGITEMS

ALL

ALLEXCEPT

ALLNOBLANKROW

ALLSELECTED

CALCULATE

CALCULATETABLE

CROSSFILTER function

DISTINCT

EARLIER

EARLIEST

FILTER

FILTERS

HASONEFILTER

HASONEVALUE

ISCROSSFILTERED

ISFILTERED

KEEPFILTERS

RELATED

RELATEDTABLE

SELECTEDVALUE

SUBSTITUTEWITHINDEX

USERELATIONSHIP

VALUES