This reference lists 15 DAX information functions, with frequently used functions marked 🔥. Each function includes syntax, an example and parameter notes.
| Function | Description | Syntax | Example |
|---|---|---|---|
ISBLANK 🔥 |
Checks whether a value is blank | ISBLANK(<value>) |
ISBLANK(Sales[Amount]) |
HASONEFILTER |
Checks whether the column has exactly one filter | HASONEFILTER(<columnName>) |
HASONEFILTER(Sales[Region]) |
ISCROSSFILTERED |
Checks whether the column is cross-filtered | ISCROSSFILTERED(<columnName>) |
ISCROSSFILTERED(Sales[ProductID]) |
ISEMPTY |
Checks whether a table is empty | ISEMPTY(<table>) |
ISEMPTY(Sales) |
ISERROR |
Checks whether a value is an error | ISERROR(<value>) |
ISERROR(1/0) |
ISFILTERED |
Checks whether the column is filtered directly | ISFILTERED(<columnName>) |
ISFILTERED(Sales[Region]) |
ISINSCOPE |
Checks whether the column is in scope | ISINSCOPE(<columnName>) |
IF(ISINSCOPE(Sales[Region]), "Region level", "Not region level") |
ISLOGICAL |
Checks whether a value is a logical value | ISLOGICAL(<value>) |
ISLOGICAL(TRUE()) |
ISMEASURE |
Checks whether the expression is a measure | ISMEASURE(<expression>) |
ISMEASURE([Total Sales]) |
ISNUMBER |
Checks whether a value is a number | ISNUMBER(<value>) |
ISNUMBER("123") |
ISONORAFTER |
Checks whether a value is on or after another value (used for sorting) | ISONORAFTER(<scalar_expression>, <scalar_expression>, [<sort_order>]) |
FILTER(Sales, ISONORAFTER(Sales[Amount], 1000, ASC)) |
ISSUBTOTAL |
Checks whether the current row is a subtotal row for the given column | ISSUBTOTAL(<column>) |
ISSUBTOTAL(Sales[Year]) |
ISTEXT |
Checks whether a value is text | ISTEXT(<value>) |
ISTEXT("Hello") |
USERNAME |
Returns the domain and username of the current user | USERNAME() |
USERNAME() |
USERPRINCIPALNAME |
Returns the user principal name of the current user | USERPRINCIPALNAME() |
USERPRINCIPALNAME() |
Detailed parameters for frequently used functions
ISBLANK
Checks whether a value is blank.
| Parameter | Description |
|---|---|
value |
The value or expression to check. |
From Online Toolbox (www.vba.net)