Forum Discussion
Top 10 with Multiple Columns
Hi,
Please follow a 5 steps process:
1. Get the Rank of NOC Colum like this:
NOC_Rank =
RANKX(
ALL(TicketData),
TicketData[NOC Completed Rate (Within 24 hours)],
,
DESC,
Dense
)
2. Get the rank of FTR column:
FTR_Rank =
RANKX(
ALL(TicketData),
TicketData[FTR Percentage],
,
DESC,
Dense
)
3. Combined the ranks:
Combined_Rank = [NOC_Rank] + [FTR_Rank]
4. Get the final rank:
Final_Rank =
RANKX(
ALL(TicketData),
[Combined_Rank],
,
ASC,
Dense
)
5. Finally, you can get a new table as follows:
Top10Table =
FILTER(
ALL(TicketData),
[Final_Rank] <= 10
)
I hope this will solve your problem.
- saud9683 years ago
Memorable Member
The filter one did not work rest all worked