DAX Path CEO Not working

[Ahmadbelal]

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. 

[OwenAuger]

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