Forum Discussion
Remove Nulls
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
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.
5 Replies
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.
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 () )