Forum Discussion
Solved
Rank dax - power bi
Hello guys I'm trying to make rank for this table for number of employees at (cairo - suez - alex ) regions only and i wanted to get maximum three for all these regions and make cards for everey ...
mo_nasser , Assume you have a count of employee measure - Employee
Create a rank and use this in the visual level filter
Rank = Rankx(allselected(Table[regions]), [Employee],,desc,dense)
Or create a measure
Concatenatex(Filter(Values(Table[Regions]) , [Rank] =1) , Max(Table[Age Group]) & unichar(10) & Max(Table[Age gender] ) , " , ")
Add others as per need
amitchandak
Super User
Super Usermo_nasser , Assume you have a count of employee measure - Employee
Create a rank and use this in the visual level filter
Rank = Rankx(allselected(Table[regions]), [Employee],,desc,dense)
Or create a measure
Concatenatex(Filter(Values(Table[Regions]) , [Rank] =1) , Max(Table[Age Group]) & unichar(10) & Max(Table[Age gender] ) , " , ")
Add others as per need
thank you , solved