Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RANK Problem

Hello,

 

When I tried to make RANKX formula, I mostly succeed. But as you see below, some number(nr 19) does not exist in the table in rank column which includes formula. Can you help me ?

 

Rank Formula = 

IF([Sum of Sales]<>BLANK(),RANKX(ALL(seller[DistName]),[Sum of Sales],,DESC),BLANK())
 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Again ,

     

    Is there anybody here who can solve my issue , I will be glad if some of you solve my issue.

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      Hi Anonymous ,

      Please try to change the function of ALL to ALLNOBLANKROW or ALLSELECTED. If it still doesn't work, please share your entire table. You could mask the sensitive data. For the data that you attached, I can't use it to reproduce the result.

       

      Best Regards,

      Xue Ding

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      Hi Anonymous ,

      Do you try to change the function? Does it work? If you have solved the issue, please accept the helpful answer. If you solved by yourself, welcome to share the solution. More people who encounter the same problem will benefit here.

       

      Best Regards,

      Xue Ding

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.