This topic has not yet been rated - Rate this topic

PATHLENGTH Function (DAX)

SQL Server 2012

Returns the number of parents to the specified item in a given PATH result, including self.

PATHLENGTH(<path>)

Parameters

path: A text expression resulting from evaluation of a PATH function.

Return Value

The number of items that are parents to the specified item in a given PATH result, including the specified item.

Remarks

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.

Example

The following example takes an employee ID as input to a PATH function and returns a list of the managers above that employee in the hierarchy, The PATHLENGTH function takes that result and counts the different levels of employees and managers, including the employee you started with.

=PATHLENGTH(PATH(Employee[EmployeeKey], Employee[ParentEmployeeKey]))

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD