PowerPivot: DAX: Filter Functions

The filter and value functions in Data Analysis Expressions (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.

Read more about the Filter Functions in this article:

• ALL
• ALLEXCEPT
• ALLNOBLANKROW
• CALCULATE
• CALCULATETABLE
• DISTINCT
• EARLIER
• EARLIEST
• FILTER
• RELATED
• RELATEDTABLE
• VALUES

Read more...