I am very new to Power Bi, I am currently having trouble to create a ranking for Bottom 25% employee. There are 3 levels of the Hierarchy: Directors, LM, and employee. I would appriciate if anyone would able to help me on this. I've tried multiple ways but it have not give me the desire result.
I would like it to display any employee who has less and equal 25% and wont show any 0%/ blank value.
NAME ---------------------RANK
Director 1 ----------------- 1
LM B 1
EMPLY BB 1
LM A 2
EMPLY AA 1
LM C 3
EMPLY CC 1
EMPLY CCA 2
Director 2 2
LM H 1
EMPLY HH 1
I have tried the 2 following but its not given the result that I am desired:
Rank by CBTs = RANKX(ALLSELECTED('Employee'[DIRECTORS],'Employee'[LM],'Employee'[EMPLY_NM]), [CBTs% Filter],, DESC)
CODE 2:
_CBTs Ranking =
VAR _Director_Ranking =
SUMX(
ADDCOLUMNS(
SUMMARIZE(
Employee,
Employee[Directors] ) ,
"@Directors RANKING",
RANKX(ALL(Employee[Directors]), [CBTs %], , DESC ) ) ,
[@Directors RANKING] )
VAR _LM_Ranking =
SUMX(
ADDCOLUMNS(
SUMMARIZE(
Employee,
Employee[LM] ) ,
"@LM RANKING",
RANKX(ALL(Employee[LM]),[CBTs %], , DESC ) ) ,
[@LM RANKING] )
VAR _Tech_Ranking =
SUMX(
ADDCOLUMNS(
SUMMARIZE(
Employee,
Employee[EMPLY_NM] ) ,
"@EMPLY RANKING",
RANKX(ALL(Employee[EMPLY_NM]), [CBTs %], , DESC ) ) ,
[@EMPLY RANKING] )
VAR _Results =
SWITCH(
TRUE(),
ISINSCOPE(Employee[EMPLY_NM]), _Tech_Ranking,
ISINSCOPE(Employee[LM]), _LM_Ranking,
ISINSCOPE(Employee[Directors]), _Director_Ranking,
BLANK()
)
RETURN
_Results
Thank you so much!
