Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PROBLEMS WITH RANKX

Hi all, Enyone else experiencing probles with the RANKX? I've soon browsed the entire web for a solution, but no matter what DAX I'm trying I get the same minor errors. My "basic" DAX (at the mome...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Anonymous ,

RANK - share =
RANKX ( ALL ( ORGANIZATION ), [SHARE], ,DESC, DENSE )
You can refer to this link .

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

Thanks for your reply & effort, but unfortunately this doesn't work either...

I've read the blog-post, but it just don't add up.

 

I have tried de-tours via both ALL and ALLSELECTED among others, but It never gets closer then 95% correct.

 

Possibly it is a result of problems with the measure (SHARE) that is ranked.

Share is again a function of misc other measures.

Maybe I need to go up the entire line one more time.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Anonymous ,
    Can you please provide the sample data in table format so I can check?
    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks, but I think I finally found the solution.

      Format the SHARE as CURRENCY.

      Ref. this article - seems to be a general DAX issue

       

      My final solution was this:

      RANK - share = RANKX(ORGANIZATION[STORE];CURRENCY([SHARE]);;DESC)

      (For some reason I also had to skip the Dense to get it correct)

       

      https://www.sqlbi.com/blog/marco/2014/07/16/use-of-rankx-with-decimal-numbers-in-dax/