Hello,
Quick intro -
I have few levels which look like Pyramid, (L1 1 value, L2 multiple values which goes into ever more values on L3 and so on until Level Node( which is level 8).
I need a measure where when I select level 2 on slicer, level 3 will pop up on the visual(table).
I have managed to do it until when level 5 is selected I get level 6 shown, but for 6 to 7 and 7 to node I cant get a correct measure.
Commented is variable written in common langugae that should be translated to DAX langugae
Cost Centers Level Below FLag =
VAR vSelectedFilterLevel =
SWITCH(
TRUE,
ISFILTERED( 'cost center'[cost center name] ), 8,
ISFILTERED( 'cost center'[cost center level7 name] ), 7,
ISFILTERED( 'cost center'[cost center level6 name] ), 6,
ISFILTERED( 'cost center'[cost center level5 name] ), 5,
ISFILTERED( 'cost center'[cost center level4 name] ), 4,
ISFILTERED( 'cost center'[cost center level3 name] ), 3,
2
)
/* This part I cant get correct ! var level7 = If selected 2-7 return vSelectedFilterLevel, else return node*/
VAR vFilteredRecords =
FILTER(
'cost center list', -- if level 2 is selected in slicer return nodes from more detailed level, level3
'cost center list'[cost center (list) level] = "Level " & vSelectedFilterLevel + 1
&& 'cost center list'[cost center wid] IN VALUES( 'cost center'[cost center wid] )
)
RETURN -- just return 1 as flag if record should be visible
IF( SUMX( vFilteredRecords,1 ) > 0, 1, 0 )
