Information Functions
Information functions provide information about data type or filter context of the argument provided.
| Function | Description |
|---|---|
| COLUMNSTATISTICS | Provides statistics regarding every column in every table in the model. |
| 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(). |
| EVALUATEANDLOG | Return the value of the first argument and also log the value in DAX evaluation log. |
| 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. |
| NAMEOF | Returns the name of a column or measure. |
| 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: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Gert Christen
2018-2023 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies