Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 1 Question 66 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?
B) Option B
A) Option A
C) option C
D) Option D

Microsoft PL-300 Exam - Topic 1 Question 66 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 66
Topic #: 1
[All PL-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Margurite at Apr 05, 2025, 03:37 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Jerlene
7 months ago
Is there a way to verify these options?
upvoted 0 times
...
Cortney
7 months ago
I think Option C could work too!
upvoted 0 times
...
Margurite
8 months ago
Definitely going with Option B!
upvoted 0 times
...
Keena
8 months ago
Wait, how do we know the hierarchy is correct?
upvoted 0 times
...
Minna
8 months ago
Option A seems like the right choice.
upvoted 0 times
...
Chi
8 months ago
I definitely remember something about counting paths in DAX, but I’m torn between Options A and C.
upvoted 0 times
...
Laurene
8 months ago
I feel like Option B looks familiar, but I’m not completely confident it’s the right choice.
upvoted 0 times
...
Dianne
9 months ago
I think we might need to use a recursive function to count the levels, but I can't recall the exact syntax.
upvoted 0 times
...
Malcom
9 months ago
I remember we practiced a similar question about calculating hierarchy levels, but I’m not sure which DAX function to use here.
upvoted 0 times
...
Nilsa
9 months 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.
upvoted 0 times
...
Rikki
9 months 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.
upvoted 0 times
...
Lettie
9 months 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.
upvoted 0 times
...
Gerardo
10 months 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.
upvoted 0 times
...
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!
upvoted 0 times
...
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.
upvoted 0 times
Han
1 year ago
Let's go with Option B then.
upvoted 0 times
...
Izetta
1 year ago
I agree, Option B looks like the most straightforward solution.
upvoted 0 times
...
Frederica
1 year ago
I think Option B might be the simpler choice.
upvoted 0 times
...
...
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.
upvoted 0 times
Fletcher
1 year ago
Yeah, I also prefer a straightforward approach like Option A.
upvoted 0 times
...
Daisy
1 year ago
I think Option A might be a better choice for a simpler solution.
upvoted 0 times
...
Jeannine
1 year ago
I agree, Option D does seem a bit complicated.
upvoted 0 times
...
...
Gladis
1 year ago
Hmm, that's interesting. Can you explain why you think Option C is the best choice?
upvoted 0 times
...
Hannah
1 year ago
I disagree, I believe Option C is the correct DAX expression to use in this scenario.
upvoted 0 times
...
Filiberto
1 year ago
I think Option B is the way to go. It's more straightforward and easy to understand.
upvoted 0 times
Yun
1 year ago
I believe Option D is the most efficient solution.
upvoted 0 times
...
Alberta
1 year ago
I'm leaning towards Option C, it seems like a good fit.
upvoted 0 times
...
Maxima
1 year ago
I think Option A might work better in this scenario.
upvoted 0 times
...
Willodean
1 year ago
I agree, Option B seems like the best choice.
upvoted 0 times
...
...
Wei
1 year 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.
upvoted 0 times
...
Gladis
1 year ago
I think we should use Option B because it seems like the most logical choice.
upvoted 0 times
...

Save Cancel