Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns TRUE if the specified item exists within the specified path.
Syntax
PATHCONTAINS(<path>, <item>)
Parameters
| Term | Definition |
|---|---|
path |
A string created as the result of evaluating a PATH function. |
item |
A text expression to look for in the path result. |
Return value
A value of TRUE if item exists in path; otherwise FALSE.
Remarks
If
itemis an integer number it is converted to text and then the function is evaluated. If conversion fails then the function returns an error.-
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following example creates a calculated column that takes a manager ID and checks a set of employees. If the manager ID is among the list of managers returned by the PATH function, the PATHCONTAINS function returns true; otherwise it returns false.
= PATHCONTAINS(PATH(Employee[EmployeeKey], Employee[ParentEmployeeKey]), "23")