Forum Discussion
Cgowdar
Advocate II
Advocate IIDisplaying Top 3 and Others based on dynamic ranking
The Requirement is to show the "Top 3" and "Others" in the Pie Chart.
Following is the sample data:
| Subject | Student | Marks |
| Maths | John | 50 |
| Maths | Sam | 60 |
| Maths | Van | 70 |
| Maths | Jim | 30 |
| Maths | Jam | 20 |
| Maths | Can | 90 |
| English | John | 20 |
| English | Sam | 30 |
| English | Van | 40 |
| English | Jim | 50 |
| English | Jam | 60 |
| English | Can | 70 |
| French | John | 55 |
| French | Sam | 75 |
| French | Van | 15 |
| French | Jim | 95 |
| French | Jam | 80 |
| French | Can | 20 |
Subject will be the filter.
need to obtain Top 3 Students based on their Marks. the ranking will change for every subject choosen from the filter.
I have tried using RANKX Function , but not able to get to the solution.
Any suggestions on this will be helpfull.
Thanks in advance
You can also use a MEASURE. This will allow you to determine RANK when you select more than 1 subject
RANK = RANKX ( ALLSELECTED ( TableName[Student ] ), CALCULATE ( SUM ( TableName[Marks] ) ), , DESC, DENSE )
9 Replies
- Zubair_Muhammad
Community Champion
How about adding a Calculated Column that will RANK students for each subject separately
RANK in each Subject = RANKX ( FILTER ( ALL ( TableName ), TableName[Subject] = EARLIER ( TableName[Subject] ) ), TableName[Marks], , DESC, DENSE )- Zubair_Muhammad
- Zubair_Muhammad
HI Cgowdar
Now you can also add another Column that will help in Pie Chart
Is Top 3 Student? = IF ( TableName[RANK in each Subject] <= 3, TableName[Student ], "Others" )