Hi All

I am using a RANKX function in Power Pivot Measure to rank the Sales figures. My figures are
-19.5 %
-14.6 %
40.3 %
1.1 %
-13.7 %
-16.1 %
0.0 %
-26.8 %
-85.5 %
-11.0 %
-18.8 %
-30.5 %
-20.7 %
-16.0 %
-89.9 %
31.9 %
-16.5 %
-10.7 %
-11.9 %
0.0 %
-11.7 %
-48.7 %
-10.5 %
-30.2 %
the measure I use is RANKX(all('Dept No'[Department]),'Trade'[Sales vs Budget]) and I get the following results
604
599
1
3
598
601
4
606
610
595
603
608
605
600
611
2
602
594
597
4
596
609
593
607
It seems that Positive numbers are ranked fine but the rank negative numbers goes wrong.

Can anyone help whether I am doing something wrong
Thanks in advance