Remove Nulls

[Anonymous]

Path 2 = 
VAR PathLen =
    PATHLENGTH ( 'Project'[WBS - Copy] )
VAR Delimiter = "."
RETURN
    IF (
        PathLen >= 2,
        'Project'[Path 1] & Delimiter
            & PATHITEM ( 'Project'[WBS - Copy], 2, TEXT ),
        BLANK()
    )

I am creating a few measures and the results will be like a tree format list

i am getting blanks for empty fields but i want them to be nulls. Otherwise my tree appears as 

1

(Blank)

1.1

1.1.1

(Blank)

Where visually, you'd imagine Blank should be 1.0 and 1.1.1.0 but they shouldnt appear either way. It should be a null

[v-lionel-msft · Accepted solution]

Hi @Anonymous ，

Does your DAX formulae return this result?

1

1.1

(Blank row)
1.1.1
(Blank row)

And is this what you want?

1

1.1

1.1.1
(Remove the blank rows)

If yes, you can use 'filter on this visual' when you use the measure in a visual.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Something so simple. There is a Hide Members selection in the Hierarchy Slicer properties.

Hide Members and voila ... (blank) is gone.

[Anonymous]

I meant to say that this is a measure also

[Anonymous]

Unfortunately, I've tried filtering.

This is my code for using the HierarchysSlicer. 

Path 1 = 
 PATHITEM('Project'[WBS - Copy],1,TEXT)

Path 2 = 
VAR PathLen =
    PATHLENGTH ( 'Project'[WBS - Copy] )
VAR Delimiter = "."
RETURN
  IF(
        PathLen >=2,
        'Project'[Path 1] & Delimiter
            & PATHITEM ( 'Project'[WBS - Copy], 2, TEXT ),
       BLANK()
    )

Path 3 = 
VAR PathLen =
    PATHLENGTH ( 'Project'[WBS - Copy] )
VAR Delimiter = "."
RETURN
    IF (
        PathLen >=3,
        'Project'[Path 2] & Delimiter
            & PATHITEM ( 'Project'[WBS - Copy], 3, TEXT ),
        BLANK ()
    )

[Anonymous]