Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |