Hello,
I was doing 5 level hierarchy P/L report with below approach (change 0 to your measure).
Lines are in a disconnected table.
Newd =
IF (
ISINSCOPE ( qMapping[LEVEL5] ),
SWITCH (
SELECTEDVALUE ( qMapping[LEVEL5] ),
“Line Level5”, 0
),
IF (
ISINSCOPE ( qMapping[LEVEL4] ),
SWITCH (
SELECTEDVALUE ( qMapping[LEVEL4] ),
"Line Level4", 0
),
IF (
ISINSCOPE ( qMapping[LEVEL3] ),
SWITCH (
SELECTEDVALUE ( qMapping[LEVEL3] ),
"Line Level3", 0
),
IF (
ISINSCOPE ( qMapping[LEVEL2] ),
SWITCH (
SELECTEDVALUE ( qMapping[LEVEL2] ),
"Line Level2", 0
),
IF (
ISINSCOPE ( qMapping[LEVEL1] ),
SWITCH (
SELECTEDVALUE ( qMapping[LEVEL1] ),
"Line Level2", 0
)
)
)
)
)
)