Free Microsoft Power BI PL-300 Actual Exam Questions - Question 10 Discussion
Each employee has one manager as shown in the ParentEmployeelD 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?
D imo, because it also uses PATHLENGTH but with a different context that might better handle CEO as level 1 instead of 0. That subtlety could matter depending on how they want levels counted.
Option C also uses PATHLENGTH, which is specifically made to count the number of steps in a hierarchy path. That’s exactly what we need to find the level count from employee to CEO.
B tbh, because it uses PATHLENGTH which directly counts the number of steps in the hierarchy path from an employee up to the CEO. That feels like exactly what the question asks for—counting levels. I think A and C don’t really handle the hierarchical path length properly, and D looks more complicated without clear benefit. PATH and PATHLENGTH are made for this kind of parent-child relationship, so B looks like the cleanest way to do it.
B/C? I ruled out A since it looks like it just sums or counts something flat, not climbing the hierarchy. Between B and C, C seems to use PATHLENGTH which feels like the right approach for counting levels in a parent-child hierarchy. B looks close but seems more complicated without clear recursion. So I’d go with C here.
This one’s pretty tricky because the hierarchy depth function isn’t straightforward in DAX. The question's wording is kinda confusing too, doesn’t clearly say if a recursive path is needed or just simple levels.