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.

Microsoft Power BI DAX provides various types of Filter Functions such as:

ALL

CALCULATE

ALL DAX function

As it’s name suggests, Returns all the rows in a table, or all the values in a column. ALL function removes the applied filters from the filter context. Its comes under Filter function DAX category.

LOOKUPVALUE DAX Function

Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions. Its comes under Filter function DAX category.

DAX Tutorials

Search This Blog