Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove Nulls

Path 2 = VAR PathLen = PATHLENGTH ( 'Project'[WBS - Copy] ) VAR Delimiter = "." RETURN IF ( PathLen >= 2, 'Project'[Path 1] & Delimiter & PATHITEM ( 'Project'[WB...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

     

     

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

 

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

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