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)