Rank dax - power bi

[mo_nasser]

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 value of number of employees,

what i want to get ,

Thanks in advance

[amitchandak · Accepted solution]

@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

[mo_nasser]

thank you , solved