Strange behavior with ISBLANK() in PATHITEM() in DAX

[Anonymous]

Hi,

I would like to replace the blank values in Level 03 of PATHITEM with the last known parent Level 02. It still shows blank. So I tested if Level 03 has some blank values, it says no. But the data view clearly shows that there are blank values! 

What do I miss? 

Thank you for your help.

[Scottnap]

I'm trying to do the exact same thing but ISBLANK isn't working regardless of syntax.

[Nathaniel_C]

Hi @Anonymous ,

ISBLANK(<value>) is the syntax.

Not quite sure what you are trying to do with the 2, 0, but try this:

Level 03 = IF( ISBLANK (PATHITEM [PATH), PATHITEM[LEVEL 02] , PATHITEM [Path])

ISBLANK will check if the value in that cell is blank, and return a true or false.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel