MENU
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?
Suggested Answer: B
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
JE
Jerlene
10 months ago
Is there a way to verify these options?
CO
Cortney
10 months ago
I think Option C could work too!
MA
Margurite
11 months ago
Definitely going with Option B!
KE
Keena
11 months ago
Wait, how do we know the hierarchy is correct?
MI
Minna
11 months ago
Option A seems like the right choice.
CH
Chi
11 months ago
I definitely remember something about counting paths in DAX, but I’m torn between Options A and C.
LA
Laurene
12 months ago
I feel like Option B looks familiar, but I’m not completely confident it’s the right choice.
DI
Dianne
12 months ago
I think we might need to use a recursive function to count the levels, but I can't recall the exact syntax.
MA
Malcom
12 months ago
I remember we practiced a similar question about calculating hierarchy levels, but I’m not sure which DAX function to use here.
NI
Nilsa
1 year ago
This is a good test of our DAX skills. I'm going to start by thinking through the logic step-by-step, then translate that into a DAX expression.
RI
Rikki
1 year ago
Okay, I've got an idea. I think I can use the CALCULATE and PATHITEM functions to recursively walk up the hierarchy and count the number of levels.
LE
Lettie
1 year ago
I'm a bit confused on how to approach this. The hierarchy structure is clear, but I'm not sure which DAX function would be best to use to calculate the levels.
GE
Gerardo
1 year ago
This looks like a tricky one, but I think I can figure it out. I'll need to use a recursive DAX function to traverse the hierarchy and count the levels.
JO
Johanna
1 year ago
Wow, this question is really making my head spin. I hope the exam doesn't have too many of these brain-teasers!
PA
Patrick
1 year ago
Option A seems a bit convoluted. I'm going to have to study this one a bit more before I can make a confident choice.
HA
Han
1 year ago
Let's go with Option B then.
IZ
Izetta
1 year ago
I agree, Option B looks like the most straightforward solution.
FR
Frederica
1 year ago
I think Option B might be the simpler choice.
RO
Rory
1 year ago
Option D looks like it's trying to do too much. I prefer a simpler solution that just focuses on the task at hand.
FL
Fletcher
1 year ago
Yeah, I also prefer a straightforward approach like Option A.
DA
Daisy
1 year ago
I think Option A might be a better choice for a simpler solution.
JE
Jeannine
1 year ago
I agree, Option D does seem a bit complicated.
GL
Gladis
1 year ago
Hmm, that's interesting. Can you explain why you think Option C is the best choice?
HA
Hannah
1 year ago
I disagree, I believe Option C is the correct DAX expression to use in this scenario.
FI
Filiberto
2 years ago
I think Option B is the way to go. It's more straightforward and easy to understand.
YU
Yun
1 year ago
I believe Option D is the most efficient solution.
AL
Alberta
1 year ago
I'm leaning towards Option C, it seems like a good fit.
MA
Maxima
1 year ago
I think Option A might work better in this scenario.
WI
Willodean
1 year ago
I agree, Option B seems like the best choice.
WE
Wei
2 years ago
Option C looks good, but I'm not sure if it handles the edge cases where an employee has no manager or the CEO has no manager.
GL
Gladis
2 years ago
I think we should use Option B because it seems like the most logical choice.