Forum Discussion
Hierarchy skip (not hide) blank rows
Hi, my data looks something like the table below. With Lvl1 being the highest in the heirarchy and Lvl5 being the lowest. TABLE: ID Lvl1 Lvl2 Lvl3 Lvl4 Lvl5 1 Costs Financial Expe...
Hey un97, have you tried something like this?
CountRowsTable =
VAR SelectedLvl4 = VALUES(TABLE[Lvl4])
VAR SelectedLvl5 = VALUES(TABLE[Lvl5])
VAR Count = COUNTROWS(TABLE)
RETURN
SWITCH(
TRUE(),
ISINSCOPE(TABLE[Lvl5]) && ISBLANK(SelectedLvl4), CONCATENATEX(SelectedLvl5, TABLE[Lvl5], " > "),
ISINSCOPE(TABLE[Lvl4]) && ISBLANK(SelectedLvl5), CONCATENATEX(SelectedLvl4, TABLE[Lvl4], " > "),
ISINSCOPE(TABLE[Lvl3]), CONCATENATEX(VALUES(TABLE[Lvl3]), TABLE[Lvl3], " > "),
ISINSCOPE(TABLE[Lvl2]), CONCATENATEX(VALUES(TABLE[Lvl2]), TABLE[Lvl2], " > "),
ISINSCOPE(TABLE[Lvl1]), CONCATENATEX(VALUES(TABLE[Lvl1]), TABLE[Lvl1], " > "),
BLANK()
) & Count
Hi devindupree01, unfortunately this measure didn't work.
The result I got with the measure you provided is this: