Question 267 of 388
Single answerYou have a Power BI model that contains a table named Employee. The table contains the following data.Each employee has one manager as shown in the ParentEmployeeID column.All reporting paths lead to the CEO at the top of the organizational hierarchy.You need to create a calculated column that returns the count of levels from each employee to the CEO.Which DAX expression should you use?
✓APATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))
BPATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)
CPATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)
DPATH(Employee[EmployeeID],Employee[ParentEmployeeID])
✓
Correct Answer: A
PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.