CONTAINS
| The function either returns true or false depending on whether the values for all of the referred columns exist or are contained in those columns.
| CONTAINS(<table>, <column value> <value>[, <column value>, <value>]…)
|
|---|
COLUMNSATISTICS
| This function provides a statistics table for each column in each table in the model.
| COLUMNSATISTICS()
|
|---|
CONTAINSROW
| The function returns true if a row value exists or is contained in a table, or false otherwise.
| CONTAINSROW(<tableExpression>, <ScalarExpression>[, <ScalarExpression>,…])
|
|---|
CONTAINSSTRING
| Depending on whether one string contains another, this function returns true or false.
| CONTAINSSTRING(<within text>, <find text>)
|
|---|
CONTAINSSTRINGEXACT
| Whether one string contains another is indicated by a return value of TRUE or FALSE.
| CONTAINSSTRINGEXACT(<within_text>, <find_text>)
|
|---|
CUSTOMDATA
| returns the information found in the connection string's CustomData property.
| CUSTOMDATA()
|
|---|
HASONEFILTER
| If there are exactly One directly filtered values on ColumnName, the function either returns true or returns false.
| HASONEFILTER(<column name>)
|
|---|
HASONEVALUE
| If only one distinct value remains in the context for ColumnName, the function returns true; otherwise, it returns false.
| HASONEVALUE(<columnName>)
|
|---|
ISBLANK
| If the value is blank, this function returns true;
| ISBLANK(<Value>)
|
|---|
ISERROR
| If the value is an error, this function returns true; otherwise, it returns false.
| ISERROR(<value>)
|
|---|
ISLOGICAL
| This function determines if a value is logical, i.e. TRUE/FALSE: If true, it returns; if false, it returns
| ISLOGICAL(<value>)
|
|---|
ISNUMBER
| This function determines whether a value is a number before returning either true or false.
| ISNUMBER(<value>)
|
|---|
ISNONTEXT
| This function determines whether a value is nontext (blanks are treated as non-text), in which case it returns true or false.
| ISNONTEXT(<value>)
|
|---|
ISTEXT
| This function determines whether a value is text before returning true or false.
| ISTEXT(<value>)
|
|---|
ISAFTER
| a boolean function that behaves like a Start At clause and returns true for a row that satisfies all of the conditional criteria.
| ISAFTER(<scalar_expression>, <scalar_expression>[, sort_order [, <scalar_expression>, <scalar_expression>[, sort_order]]…)
|
|---|
ISCROSSFILTERED
| When columnName or another column in the same or related table is being filtered, this function returns TRUE.
| ISCROSSFILTERED(<TableNameOrColumnName>)
|
|---|
ISEMPTY
| verifies whether a table is empty.
| ISEMPTY(<table_expression>)
|
|---|
ISEVEN
| If the number is even, it returns TRUE; otherwise, it returns FALSE.
| ISEVEN(number)
|
|---|
ISFILTERED
| when columnName is being directly filtered, returns TRUE.
| ISFILTERED(<TableNameOrColumnName>)
|
|---|
ISINSCOPE
| When a column is the level in a hierarchy of levels, this function returns true.
| ISINSCOPE(<columnName>)
|
|---|
ISODD
| Returns FALSE if the number is even, or TRUE if the number is odd.
| ISODD(<value>)
|
|---|
ISONORAFTER
| a boolean function that behaves like a Start At clause and returns true for a row that satisfies all of the conditional criteria.
| ISONORAFTER(<scalar_expression>, <scalar_expression>[, sort_order [, <scalar_expression>, <scalar_expression>[, sort_order]]…)
|
|---|
ISSELECTEDMEASURE
| Expressions for calculation items use this information to determine whether the measure being referenced is one of the ones listed in the list of measures.
| ISSELECTEDMEASURE( M1, M2, ... )
|
|---|
ISSUBTOTAL
| Creates a new column in a SUMMARIZE expression that returns True if the row has values for the subtotal column specified as an argument and False otherwise.
| ISSUBTOTAL(<columnName>)
|
|---|
NONVISUAL
| identifies a value filter as non-visual in a SUMMARIZECOLUMNS expression.
| NONVISUAL(<expression>)
|
|---|
SELECTEDMEASURE
| Used in expressions for calculation items to refer to the currently referenced measure.
| SELECTEDMEASURE()
|
|---|