Ranking with hierarchy levels for bottom 25%

Question

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.&nbsp;I would like it to display any employee who has less and equal 25% and wont show any 0%/ blank value.&nbsp;NAME ---------------------RANKDirector 1 ----------------- 1&nbsp; &nbsp; &nbsp;LM B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; EMPLY BB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;LM A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; EMPLY AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;LM C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; EMPLY CC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; EMPLY CCA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2Director 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp;LM H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; EMPLY HH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1I 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(&nbsp; &nbsp; ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Employee,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Employee[Directors] ) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "@Directors RANKING",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RANKX(ALL(Employee[Directors]), [CBTs %], , DESC ) ) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [@Directors RANKING] )VAR _LM_Ranking = SUMX(&nbsp; &nbsp; ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Employee,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Employee[LM] ) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "@LM RANKING",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RANKX(ALL(Employee[LM]),[CBTs %], , DESC ) ) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [@LM RANKING] )VAR _Tech_Ranking = SUMX(&nbsp; &nbsp; ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Employee,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Employee[EMPLY_NM] ) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "@EMPLY RANKING",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RANKX(ALL(Employee[EMPLY_NM]), [CBTs %], , DESC ) ) ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [@EMPLY RANKING] )VAR _Results = &nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; ISINSCOPE(Employee[EMPLY_NM]), _Tech_Ranking,&nbsp; &nbsp; &nbsp; &nbsp; ISINSCOPE(Employee[LM]), _LM_Ranking,&nbsp; &nbsp; &nbsp; &nbsp; ISINSCOPE(Employee[Directors]), _Director_Ranking, &nbsp; &nbsp; &nbsp; &nbsp; BLANK()&nbsp; &nbsp; )RETURN&nbsp; &nbsp; _ResultsThank you so much!

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Ranking with hierarchy levels for bottom 25%

1 Reply

Related content

Matrix Visual Hierarchy Level Problem

Multi level hierarchy in Gantt chart by microsoft corporation

Duplicate ranking

Visual Level Calculations with RANK

Dynamic Y range visual calculation in two level hierarchy