# Filter Functions (DAX)

Owen Duncan|Last Updated: 4/19/2018

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

ALL Function (DAX)

ALLEXCEPT Function (DAX)

ALLNOBLANKROW Function (DAX)

ALLSELECTED Function (DAX)

CALCULATE Function (DAX)

CALCULATETABLE Function (DAX)

CROSSFILTER Function

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)

SELECTEDVALUE Function (DAX)

SUBSTITUTEWITHINDEX Function (DAX)

USERELATIONSHIP Function (DAX)

VALUES Function (DAX)

DAX Function Reference