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 (DAX)

ALLEXCEPT Function (DAX)

ALLNOBLANKROW Function (DAX)

CALCULATE Function (DAX)

CALCULATETABLE Function (DAX)

DISTINCT Function (DAX)

EARLIER Function (DAX)

EARLIEST Function (DAX)

FILTER Function (DAX)

RELATED Function (DAX)

RELATEDTABLE Function (DAX)

VALUES Function (DAX)

Reference

Getting Started with Data Analysis Expressions (DAX)

DAX Syntax Specification

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trigonometric Functions (DAX)

See Also

Other Resources

Getting Started with Data Analysis Expressions (DAX)