Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful 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.

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

itchyeyeballs

 

With part of data you provided, I could not correctly identify the problem. You can take a look at the last part of this blog. It explains how rankx works when we specific the third value argument.

If possible, you can post more data here to help address the problem.

 

Best Regards,

Herbert

  • itchyeyeballs's avatar
    itchyeyeballs
    Icon for Impactful Individual rankImpactful 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
        Icon for Impactful Individual rankImpactful 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.