Forum Discussion
Help with Ranking and Quintile Calculation
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 average Quitile score overall (belowyou can see that still it doesnt show the highest quintile avg score even after applying the DAX mentioned by techies ) and also would be great if I can show all the quintiles 1,2,3,4,5 in a table with the average lowest and highest . It just assigns only Quintile 1 to the scores and I cant figure it out why . Thanks for your help
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.