DAX Information Functions

Name	Syntax	Output	Category	Description	Status
ISBLANK	`ISBLANK(<value>)`	TRUE or FALSE	Information	Checks whether a value is blank, and returns TRUE or FALSE	Done
SELECTEDMEASURENAME	`SELECTEDMEASURENAME()`	Text string (measure name)	Information	Used by expressions for calculation items to determine the name of the measure that is in context
COLUMNSTATISTICS	`COLUMNSTATISTICS()`	Returns a table with column statistics	Information	Returns a table of statistics regarding every column in every table in the model
SELECTEDMEASUREFORMATSTRING	`SELECTEDMEASUREFORMATSTRING()`	Format string (e.g., "#,##0.00")	Information	Used by expressions for calculation items to apply a format string to the measure that is in context
USERPRINCIPALNAME	`USERPRINCIPALNAME()`	Text string (e.g., "user@domain.com")	Information	Returns the user principal name
USEROBJECTID	`USEROBJECTID()`	Text string (object ID)	Information	Returns the current user object ID
USERCULTURE	`USERCULTURE()`	Text string (e.g., "en-GB")	Information	Returns the culture code of the current user
USERNAME	`USERNAME()`	Text string (e.g., "DOMAINUsername")	Information	Returns the domain name and username from the credentials given to the system at connection time
CUSTOMDATA	`CUSTOMDATA()`	Text string (e.g., "CustomData123")	Information	Returns the value of the CustomData property in the connection string
SELECTEDMEASURE	`SELECTEDMEASURE()`	Measure value (variant)	Information	Used by expressions for calculation items to reference the measure that is in context
ISFILTERED	`ISFILTERED(<columnName>)`	TRUE or FALSE	Information	Returns TRUE when columnName or another column in the same or related table is being filtered
NONVISUAL	`NONVISUAL(<expression>)`	Modified table expression	Information	Marks a value filter in SUMMARIZECOLUMNS function as not affecting measure values
HASONEFILTER	`HASONEFILTER(<columnName>)`	TRUE or FALSE	Information	Returns TRUE when the number of directly filtered values on columnName is one
ISCROSSFILTERED	`ISCROSSFILTERED(<columnName>)`	TRUE or FALSE	Information	Returns TRUE when columnName or another column in the same or related table is being filtered
ISONORAFTER	`ISONORAFTER(<scalar_expression>, <scalar_expression>, [<scalar_expression>, <scalar_expression>]…)`	TRUE or FALSE	Information	A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all the condition parameters
ISEMPTY	`ISEMPTY(<table_expression>)`	TRUE or FALSE	Information	Checks if a table is empty
HASONEVALUE	`HASONEVALUE(<columnName>)`	TRUE or FALSE	Information	Returns TRUE when the context for columnName has been filtered down to one distinct value only
ISAFTER	`ISAFTER(<scalar_expression>, <scalar_expression>, [<scalar_expression>, <scalar_expression>]…)`	TRUE or FALSE	Information	A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all the condition parameters
ISINSCOPE	`ISINSCOPE(<columnName>)`	TRUE or FALSE	Information	Returns true when the specified column is the level in a hierarchy of levels
ISSTRING	`ISSTRING(<value>)`	TRUE or FALSE	Information	Checks whether a value is a text string and returns TRUE or FALSE
ISODD	`ISODD(<number>)`	TRUE or FALSE	Information	Returns TRUE if the number is odd
ISNUMERIC	`ISNUMERIC(<value>)`	TRUE or FALSE	Information	Checks whether a value is numeric and returns TRUE or FALSE
ISEVEN	`ISEVEN(<number>)`	TRUE or FALSE	Information	Returns TRUE if the number is even
ISTEXT	`ISTEXT(<value>)`	TRUE or FALSE	Information	Checks whether a value is text and returns TRUE or FALSE
ISERROR	`ISERROR(<value>)`	TRUE or FALSE	Information	Checks whether a value is an error and returns TRUE or FALSE
ISNUMBER	`ISNUMBER(<value>)`	TRUE or FALSE	Information	Checks whether a value is a number and returns TRUE or FALSE
ISINTEGER	`ISINTEGER(<value>)`	TRUE or FALSE	Information	Checks whether a value is an integer and returns TRUE or FALSE
ISNONTEXT	`ISNONTEXT(<value>)`	TRUE or FALSE	Information	Checks whether a value is not text and returns TRUE or FALSE
ISINT64	`ISINT64(<value>)`	TRUE or FALSE	Information	Checks whether a value is an integer and returns TRUE or FALSE
CONTAINSSTRING	`CONTAINSSTRING(<within_text>, <find_text>)`	TRUE or FALSE	Information	Returns TRUE if the specified string contains any of the specified substrings
ISCURRENCY	`ISCURRENCY(<value>)`	TRUE or FALSE	Information	Checks whether a value is a currency value and returns TRUE or FALSE
ISDATETIME	`ISDATETIME(<value>)`	TRUE or FALSE	Information	Returns TRUE if the specified value is a date/time value
ISBOOLEAN	`ISBOOLEAN(<value>)`	TRUE or FALSE	Information	Checks whether a value is a Boolean value and returns TRUE or FALSE
CONTAINSSTRINGEXACT	`CONTAINSSTRINGEXACT(<within_text>, <find_text>)`	TRUE or FALSE	Information	Returns TRUE if the specified string contains the specified substring
ISDECIMAL	`ISDECIMAL(<value>)`	TRUE or FALSE	Information	Checks whether a value is a decimal number and returns TRUE or FALSE
ISLOGICAL	`ISLOGICAL(<value>)`	TRUE or FALSE	Information	Checks whether a value is a logical value and returns TRUE or FALSE
CONTAINSROW	`CONTAINSROW(<table>, <value1>, <value2>, …)`	TRUE or FALSE	Information	Returns TRUE if a row of values exists or contained in a table
CONTAINS	`CONTAINS(<table>, <columnName>, <value>, [<columnName>, <value>]…)`	TRUE or FALSE	Information	Returns true if values for all referred columns exist, or are contained, in those columns
ISSUBTOTAL	`ISSUBTOTAL(<column>)`	TRUE or FALSE	Information	Creates another column in a SUMMARIZE expression that returns True if the row contains subtotal values for the column given as argument, otherwise returns False.
ISDOUBLE	`ISDOUBLE(<value>)`	TRUE or FALSE	Information	Checks whether a value is a floating-point number, and returns TRUE or FALSE.
ISSELECTEDMEASURE	`ISSELECTEDMEASURE(<M1>, <M2>, …)`	TRUE or FALSE	Information	Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.