# PATHCONTAINS

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 item is 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")