Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Calculated column Calculated table Measure Visual calculation
Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.
CONTAINS(<table>, <columnName>, <value>[, <columnName>, <value>]…)
Term | Definition |
---|---|
table |
Any DAX expression that returns a table of data. |
columnName |
The name of an existing column, using standard DAX syntax. It cannot be an expression. |
value |
Any DAX expression that returns a single scalar value, that is to be sought in columnName . The expression is to be evaluated exactly once and before it is passed to the argument list. |
A value of TRUE
if each specified value
can be found in the corresponding columnName
, or are contained, in those columns; otherwise, the function returns FALSE
.
The arguments columnName
and value
must come in pairs; otherwise an error is returned.
columnName
must belong to the specified table
, or to a table that is related to table
.
If columnName
refers to a column in a related table then it must be fully qualified; otherwise, an error is returned.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following example creates a measure that tells you whether there were any Internet sales of product 214 and to customer 11185 at the same time.
= CONTAINS(InternetSales, [ProductKey], 214, [CustomerKey], 11185)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today