Information Functions


Information functions provide information about data type or filter context of the argument provided.

Function Description
CONTAINS Returns TRUE if there exists at least one row where all columns have specified values.
CONTAINSROW Returns TRUE if there exists at least one row where all columns have specified values.
CONTAINSSTRING Returns TRUE if one text string contains another text string. CONTAINSSTRING is not case-sensitive, but it is accent-sensitive.
CONTAINSSTRINGEXACT Returns TRUE if one text string contains another text string. CONTAINSSTRINGEXACT is case-sensitive and accent-sensitive.
CUSTOMDATA Returns the value of the CustomData connection string property if defined; otherwise, BLANK().
HASONEFILTER Returns true when the specified table or column has one and only one value resulting from direct filter(s).
HASONEVALUE Returns true when there's only one value in the specified column.
ISAFTER Returns true if the list of Value1 parameters compares strictly after the list of Value2 parameters.
ISBLANK Checks whether a value is blank, and returns TRUE or FALSE.
ISCROSSFILTERED Returns true when the specified table or column is crossfiltered.
ISEMPTY Returns true if the specified table or table-expression is Empty.
ISERROR Checks whether a value is an error, and returns TRUE or FALSE.
ISEVEN Returns TRUE if number is even, or FALSE if number is odd.
ISFILTERED Returns true when there are direct filters on the specified column.
ISINSCOPE Returns true when the specified column is the level in a hierarchy of levels.
ISLOGICAL Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.
ISNONTEXT Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.
ISNUMBER Checks whether a value is a number, and returns TRUE or FALSE.
ISODD Returns TRUE if number is odd, or FALSE if number is even.
ISONORAFTER The IsOnOrAfter function is a boolean function that emulates the behavior of Start At clause and returns true for a row that meets all the conditions mentioned as parameters in this function.
ISSELECTEDMEASURE Returns true if one of the specified measures is currently being evaluated.
ISSUBTOTAL Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise.
ISTEXT Checks whether a value is text, and returns TRUE or FALSE.
NONVISUAL Mark the filter as NonVisual.
SELECTEDMEASURE Returns the measure that is currently being evaluated.
SELECTEDMEASUREFORMATSTRING Returns format string for the measure that is currently being evaluated.
SELECTEDMEASURENAME Returns name of the measure that is currently being evaluated.
USERCULTURE Returns the culture code for the user, based on their operating system or browser settings.
USERNAME Returns the domain name and user name of the current connection with the format of domain-name\user-name.
USEROBJECTID Returns the current user's Object ID from Azure AD for Azure Analysis Server and the current user's SID for on-premise Analysis Server.
USERPRINCIPALNAME Returns the user principal name.

Last update: Oct 19, 2020   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Gert Christen

Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Iterator

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Deprecated

This parameter is deprecated and its use is not recommended.

Contribute

Want to improve the content of ISAFTER? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.