Forum Discussion
Remove Nulls
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi 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.
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 ()
)