Forum Discussion

rui_silva's avatar
rui_silva
Icon for Helper I rankHelper I
8 years ago
Solved

RANKX showing duplicated values

Hi, I getting a issue where when i try to use RANKX to rank some data im getting duplicated values  Measure im using : rankx(allselected(Dados[Turmas/Ano]); calculate(SUMX(Dados;Dados[MódulosAtraso...
Need Help
  • rui_silva's avatar
    rui_silva
    8 years ago

    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 

     

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi rui_silva

 

This calculated column matches your expected results

 

My Rank = RANKX('Table','Table'[MódulosAtraso])
rui_silva's avatar
rui_silva
Icon for Helper I rankHelper I
8 years ago

Hey thanks for helping me but when i try use your function it gives me a error :

A single value for column 'MódulosAtraso' in table 'Dados' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.