Logical Functions

Logical functions act upon an expression to return information about the values or sets in the expression.

For example, you can use the IF function to check the result of an expression and create conditional results.

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

SWITCH

IFERROR

AND

NOT

COALESCE

TRUE

FALSE

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