Forum Discussion
DAX Path CEO Not working
Good day everyone, I am kinda having trouble while doing the DAX PATH formula. I have adjusted all the employee entries so that every active employee is linked to an active manager; however, the...
OwenAuger
Super User
Super UserHi Ahmadbelal
Can you check if the CEO's [Manager Person Number] is actually blank?
You can check this by adding a calculated column such as
Manager Blank =
ISBLANK ( 'Dim Managers Path'[Manager Person Number] )
which should return True if it is indeed blank.
In Power Query, it should appear as null.
If it's not, you will need to modify the source or query to replace with a null value.
Regards