⚓

DAX Information Functions 🧠

Status	Function	Description
Not started	COLUMNSTATISTICS	Returns a table of statistics regarding every column in every table in the model.
Not started	CONTAINS	Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.
Not started	CONTAINSROW	Returns `TRUE` if a row of values exists or contained in a table, otherwise returns `FALSE`.
Not started	CONTAINSSTRING	Returns `TRUE` or `FALSE` indicating whether one string contains another string.
Not started	CONTAINSSTRINGEXACT	Returns `TRUE` or `FALSE` indicating whether one string contains another string.
Not started	CUSTOMDATA	Returns the content of the CustomData property in the connection string.
Not started	HASONEFILTER	Returns TRUE when the number of directly filtered values on `columnName` is one; otherwise returns `FALSE`.
Not started	HASONEVALUE	Returns `TRUE` when the context for `columnName` has been filtered down to one distinct value only. Otherwise is `FALSE`.
Not started	ISAFTER	A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters.
Not started	ISBLANK	Checks whether a value is blank, and returns `TRUE` or `FALSE`.
Not started	ISBOOLEAN	Checks whether a value is a logical value, (`TRUE` or `FALSE`), and returns `TRUE` or `FALSE`. Alias of ISLOGICAL.
Not started	ISCROSSFILTERED	Returns `TRUE` when `columnName` or another column in the same or related table is being filtered.
Not started	ISCURRENCY	Checks whether a value is a decimal number, and returns `TRUE` or `FALSE`. Alias of ISDECIMAL.
Not started	ISDATETIME	Checks whether a value is a date / time, and returns `TRUE` or `FALSE`.
Not started	ISDECIMAL	Checks whether a value is a decimal number, and returns `TRUE` or `FALSE`. Alias of ISCURRENCY.
Not started	ISDOUBLE	Checks whether a value is a floating-point number, and returns `TRUE` or `FALSE`.
Not started	ISEMPTY	Checks if a table is empty.
Not started	ISERROR	Checks whether a value is an error, and returns `TRUE` or `FALSE`.
Not started	ISEVEN	Returns `TRUE` if number is even, or `FALSE` if number is odd.
Not started	ISFILTERED	Returns `TRUE` when `columnName` is being filtered directly.
Not started	ISINSCOPE	Returns true when the specified column is the level in a hierarchy of levels.
Not started	ISINT64	Checks whether a value is a whole number, and returns `TRUE` or `FALSE`. Alias of ISINTEGER.
Not started	ISINTEGER	Checks whether a value is a whole number, and returns `TRUE` or `FALSE`. Alias of ISINT64.
Not started	ISLOGICAL	Checks whether a value is a logical value, (`TRUE` or `FALSE`), and returns `TRUE` or `FALSE`. Alias of ISBOOLEAN.
Not started	ISNONTEXT	Checks if a value is not text (blank cells are not text), and returns `TRUE` or `FALSE`.
Not started	ISNUMBER	Checks whether a value is a number, and returns `TRUE` or `FALSE`. Alias of ISNUMERIC.
Not started	ISNUMERIC	Checks whether a value is a number, and returns `TRUE` or `FALSE`. Alias of ISNUMBER.
Not started	ISODD	Returns `TRUE` if number is odd, or `FALSE` if number is even.
Not started	ISONORAFTER	A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters.
Not started	ISSELECTEDMEASURE	Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.
Not started	ISSTRING	Checks if a value is text, and returns `TRUE` or `FALSE`. Alias of ISTEXT.
Not started	ISSUBTOTAL	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.
Not started	ISTEXT	Checks if a value is text, and returns `TRUE` or `FALSE`. Alias of ISSTRING.
Not started	NONVISUAL	Marks a value filter in a SUMMARIZECOLUMNS expression as non-visual.
Not started	SELECTEDMEASURE	Used by expressions for calculation items to reference the measure that is in context.
Not started	SELECTEDMEASUREFORMATSTRING	Used by expressions for calculation items to retrieve the format string of the measure that is in context.
Not started	SELECTEDMEASURENAME	Used by expressions for calculation items to determine the measure that is in context by name.
Not started	USERCULTURE	Returns the locale for the current user.
Not started	USERNAME	Returns the domain name and username from the credentials given to the system at connection time.
Not started	USEROBJECTID	Returns the current user's Object ID or SID.
Not started	USERPRINCIPALNAME	Returns the user principal name.