Filter Functions (DAX)

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. For a discussion of context, see Context in DAX Formulas.

In This Section

ALL Function

ALLEXCEPT Function

ALLNOBLANKROW Function

ALLSELECTED Function (DAX)

CALCULATE Function

CALCULATETABLE Function

DISTINCT Function

EARLIER Function

EARLIEST Function

FILTER Function

FILTERS Function (DAX)

HASONEFILTER Function (DAX)

HASONEVALUE Function (DAX)

ISCROSSFILTERED Function (DAX)

ISFILTERED Function (DAX)

RELATED Function

RELATEDTABLE Function

VALUES Function

Reference

Data Analysis Expressions (DAX) Overview

DAX Syntax Specification for PowerPivot

Related Sections

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trig Functions (DAX)

See Also

Concepts

Data Analysis Expressions (DAX) Overview