PATHITEM Function (DAX)
Returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted from left to right.
This function can be used to return a specific level from a hierarchy returned by a PATH function. For example, you could return just the skip-level managers for all employees.
If you specify a number for position that is less than one (1) or greater than the number of elements in path, the PATHITEM function returns BLANK
If type is not a valid enumeration element an error is returned.
This DAX function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, see http://go.microsoft.com/fwlink/?LinkId=219172.
The following example returns the third tier manager of the current employee; it takes the employee and manager IDs as the input to a PATH function that returns a string with the hierarchy of parents to current employee. From that string PATHITEM returns the third entry as an integer.
=PATHITEM(PATH(Employee[EmployeeKey], Employee[ParentEmployeeKey]), 3, 1)