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.
INFO.ALTERNATEOFDEFINITIONS
INFO.ANNOTATIONS Returns a list of all annotations in the current model with columns matching the schema rowset for annotation objects.
INFO.ATTRIBUTEHIERARCHIES Represents the TMSCHEMA_ATTRIBUTE_HIERARCHIES DMV query function.
INFO.ATTRIBUTEHIERARCHYSTORAGES
INFO.CALCDEPENDENCY Returns information about the calculation dependency for a DAX query.
INFO.CALCULATIONGROUPS
INFO.CALCULATIONITEMS
INFO.CATALOGS Represents the DBSCHEMA_CATALOGS DMV query function.
INFO.CHANGEDPROPERTIES Represents the TMSCHEMA_CHANGED_PROPERTIES DMV query function.
INFO.COLUMNPARTITIONSTORAGES
INFO.COLUMNPERMISSIONS Returns a list of all column permissions in the current model with columns matching the schema rowset for column permissions objects.
INFO.COLUMNS Returns a list of all columns in the current model with columns matching the schema rowset for column objects.
INFO.COLUMNSTORAGES Returns a list of all column storages in the current model with columns matching the schema rowset for column storage objects.
INFO.CULTURES Returns a list of all cultures in the current model with columns matching the schema rowset for culture objects.
INFO.DATACOVERAGEDEFINITIONS
INFO.DATASOURCES Represents the TMSCHEMA_DATASOURCES DMV query function.
INFO.DELTATABLEMETADATASTORAGES
INFO.DETAILROWSDEFINITIONS Returns a list of all detail rows definitions in the current model with columns matching the schema rowset for detail rows definitions objects.
INFO.DICTIONARYSTORAGES
INFO.EXCLUDEDARTIFACTS Represents the TMSCHEMA_EXCLUDED_ARTIFACTS DMV query function.
INFO.EXPRESSIONS Returns a list of all expressions in the current model with columns matching the schema rowset for expressions objects.
INFO.EXTENDEDPROPERTIES Returns a list of all extended properties in the current model with columns matching the schema rowset for extended properties objects.
INFO.FORMATSTRINGDEFINITIONS
INFO.FUNCTIONS Returns information about the functions that are currently available for use in the DAX programming language.
INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES
INFO.GROUPBYCOLUMNS
INFO.HIERARCHIES Represents the TMSCHEMA_HIERARCHIES DMV query function.
INFO.HIERARCHYSTORAGES
INFO.KPIS Returns a list of all KPIS in the current model with columns matching the schema rowset for KPI objects.
INFO.LEVELS Returns a list of all levels in the current model with columns matching the schema rowset for level objects.
INFO.LINGUISTICMETADATA Represents the TMSCHEMA_LINGUISTIC_METADATA DMV query function.
INFO.MEASURES Returns a list of all measures in the current model with columns matching the schema rowset for measure objects.
INFO.MODEL Represents the TMSCHEMA_MODEL DMV query function.
INFO.OBJECTTRANSLATIONS Returns a list of all object translations in the current model with columns matching the schema rowset for object translation objects.
INFO.PARQUETFILESTORAGES
INFO.PARTITIONS Represents the TMSCHEMA_PARTITIONS DMV query function.
INFO.PARTITIONSTORAGES Returns a list of all partition storages in the current model with columns matching the schema rowset for partition storage objects.
INFO.PERSPECTIVECOLUMNS Returns a list of all perspective columns in the current model with columns matching the schema rowset for perspective columns objects.
INFO.PERSPECTIVEHIERARCHIES Returns a list of all perspective hierarchies in the current model with columns matching the schema rowset for perspective hierarchies objects.
INFO.PERSPECTIVEMEASURES Returns a list of all perspective measures in the current model with columns matching the schema rowset for perspective measures objects.
INFO.PERSPECTIVES Returns a list of all perspectives in the current model with columns matching the schema rowset for perspectives objects.
INFO.PERSPECTIVETABLES Returns a list of all perspective tables in the current model with columns matching the schema rowset for perspective tables objects.
INFO.PROPERTIES Represents the DISCOVER_PROPERTIES DMV query function.
INFO.QUERYGROUPS
INFO.REFRESHPOLICIES
INFO.RELATEDCOLUMNDETAILS
INFO.RELATIONSHIPINDEXSTORAGES
INFO.RELATIONSHIPS Represents the TMSCHEMA_RELATIONSHIPS DMV query function.
INFO.RELATIONSHIPSTORAGES
INFO.ROLEMEMBERSHIPS Returns a list of all role memberships in the current model with columns matching the schema rowset for role memberships objects.
INFO.ROLES Returns a list of all roles in the current model with columns matching the schema rowset for roles objects.
INFO.SEGMENTMAPSTORAGES Returns a list of all segment map storages in the current model with columns matching the schema rowset for segment map storage objects.
INFO.SEGMENTSTORAGES
INFO.STORAGEFILES Returns a list of all storage files in the current model with columns matching the schema rowset for storage file objects.
INFO.STORAGEFOLDERS Returns a list of all storage folders in the current model with columns matching the schema rowset for storage folder objects.
INFO.STORAGETABLECOLUMNS Returns statistics about the columns of in-memory tables.
INFO.STORAGETABLECOLUMNSEGMENTS Returns information about the column segments used for storing data for in-memory tables.
INFO.TABLEPERMISSIONS Returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects.
INFO.TABLES Returns a list of all tables in the current model with columns matching the schema rowset for table objects.
INFO.TABLESTORAGES Returns a list of all table storages in the current model with columns matching the schema rowset for table storage objects.
INFO.VARIATIONS Returns a list of all variations in the current model with columns matching the schema rowset for variations objects.
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 13, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Gert Christen

2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

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.

Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

Deprecated

This parameter is deprecated and its use is not recommended.

DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

Contribute

Want to improve the content of INFO.PROPERTIES? 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.