Ranking with hierarchy levels for bottom 25%
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!