Forum Discussion
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...
Hello Anonymous ,
Can you please provide the sample data in table format so I can check?
Thanks
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/