Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
10 years ago
Solved

rankx problem

Hi All,   I've got a problem with RankX that is proving difficult to resolve, would very much appreciate some assitance.   My rankX function looks like RANKX(ALLSELECTED([Name]),[col3],[col1],DE...
  • itchyeyeballs's avatar
    itchyeyeballs
    10 years ago

    Hi,

     

    I solved the issue late last night, either its a bug in the Dax function or I'm missunderstanding how it works.

     

    To resolve I had to exclude the search value from the the underling list of values to be ranked against, it seems Dax was sometimes ranking an idenitcal value below itself hence adding 1 to the rank.

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
10 years ago

Hi,

 

I solved the issue late last night, either its a bug in the Dax function or I'm missunderstanding how it works.

 

To resolve I had to exclude the search value from the the underling list of values to be ranked against, it seems Dax was sometimes ranking an idenitcal value below itself hence adding 1 to the rank.

cedric_267's avatar
cedric_267
Frequent Visitor
4 years ago

It's a little bit late, but can you share the solution / your new fonction ?

  • itchyeyeballs's avatar
    itchyeyeballs
    Impactful Individual
    4 years ago

    Hi,

     

    I can't find the code I used but I think I just used a filter to exclude the extra value from the table passed to the rank function.