Forum Discussion

Ahmadbelal's avatar
Ahmadbelal
New Member
3 years ago

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 CEO doesn't have a Manager, so his record of Manager ID, Manager Name, Manager position are all blank. I get this error. The below blank value is referring to the record of the CEO

 

The value '' in 'Dim Managers Path'[Manager Person Number] must also exist in 'Dim Managers Path'[Person Number]. Please add the missing data and try again.

 

 

Thank you in advance. 

 

 

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    3 years ago

    Hi 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