Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |