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,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
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.
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