Forum Discussion
Helper IRANKX showing duplicated values
tex628 Thanks for all the help i already found a way to show the information i wanted so instead of using my SchoolName i used the ClassID and now its showing the results i wanted .
As my ClassID they have schools names abbreviated as for examples PORGpsi1619 , i made table with the abreviattions and the school names so in the meetups people can understand what the 3 first letters means
May try to use the following DAX, add more conditions in ALL functions
Rank = RANKX(ALL(School[NameofClass],School[School]),CALCULATE(SUM(School[MódulosAtraso])),,DESC)
Helper IAnonymous hey thanks for the help but when i use your formula it gives me a error :
All column arguments of the ALL/ALLNOBLANKROW function must be from the same table.
This is my relationship if it helps :
Im going to translate the tables because they are in portuguese so table "Escola" = School where u have IdSchool and SchoolName
"Turmas"="ClassData" in this table is where i get have my table with all ids matching up .
"Dados" = "Class" where i have ClassName and MódulosAtraso
- tex628
Community Champion
May I ask what is the purpose of creating this ranking, is it to filter on rank or simply to display the rank?
/ J
- rui_silva
tex628 the purpose of this rank is to show in meeting to show the top 5 class with more "MódulosAtraso" in our group of Schools , the ranks its already filter to show only top 5
- tex628
Try this:
Go into filtersChosoe Top N instead of basicWrite 5 in top and then by value "ModuloAtraso"
