Forum Discussion
Help with Ranking and Quintile Calculation
Hello everyone, I’m working on a mock schools test scores dashboard in Power BI, and I need help calculating: The average score of the lowest and highest quintile The ability for u...
Hi,
I am still unable to understand the desired result. If possible, can you share the download link of an MS Excel file. In that file, via Excel formulas, show the desired result. I will try to translate those formulas into measures.
Hi Ashish_Mathur
This is a sample of what the data file looks like with about 500 rows of unique IDs:
| School name | Gender | Result | student ID |
| School 1 | F | 9 | 97284822 |
| School 1 | M | 15 | 35221385 |
| School 1 | F | 21 | 44096142 |
| School 10 | M | 25 | 59477716 |
| School 10 | F | 24 | 25130363 |
| School 10 | M | 10 | 92790440 |
| School 10 | M | 25 | 78879765 |
| School 10 | M | 25 | 82761570 |
| School 2 | F | 16 | 31826038 |
| School 2 | F | 19 | 76562155 |
| School 2 | M | 12 | 44052510 |
| School 2 | M | 24 | 49889759 |
| School 2 | F | 20 | 72768887 |
| School 2 | M | 20 | 74528849 |
| School 9 | F | 25 | 13687830 |
| School 2 | F | 16 | 87886232 |
| School 2 | M | 20 | 98243452 |
| School 2 | F | 18 | 91741870 |
| School 9 | F | 19 | 85182785 |
| School 2 | F | 25 | 12870447 |
| School 2 | F | 11 | 50403133 |
| School 2 | F | 17 | 99132647 |
| School 2 | F | 18 | 59752476 |
| School 2 | F | 0 | 27568371 |
| School 2 | F | 17 | 89879254 |
I am trying to show cards with lowest and highest in general and alkso would be great if I can show all the quintiles 1,2,3,4,5 in a table with the average lowest and highest perhaps . Thanks for your help