Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Using RankX in DAX For PowerPivot / PowerBI

A common reporting need is to rank a certain Attribute by a value.  In DAX, the syntax is the following: RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]])   As always, you can also r...
Show and Tell
Tips and Tricks
Pallavi's avatar
Pallavi
Helper II
8 years ago

Clearly understood the difference. Thanks.

 

I am using Rankx function on the values that ranges from positive to negative integers that are outcome of a measure doesn't give rank in order. It fails at the point when negative value starts,

 

Balance                     Rank

 

594                              1

121                              2

120                              3

106                              4

82                                5

18                                6

-28                              8                     --> should be 7

-64                              9                     --> 8

-73                             10                    -->9

 

what to do in these type of scenarios? Please help

 

  • raylenes12's avatar
    raylenes12
    Frequent Visitor
    8 years ago
    Pallavi wrote:

    Clearly understood the difference. Thanks.

     

    I am using Rankx function on the values that ranges from positive to negative integers that are outcome of a measure doesn't give rank in order. It fails at the point when negative value starts,

     

    Balance                     Rank

     

    594                              1

    121                              2

    120                              3

    106                              4

    82                                5

    18                                6

    -28                              8                     --> should be 7

    -64                              9                     --> 8

    -73                             10                    -->9

     

    what to do in these type of scenarios? Please help

     


    I'm struggling to resolve this as well, did you get any help? 

    • Sean's avatar
      Sean
      Community Champion
      8 years ago

      Okay so the reason I think no one else has chimed in here is because you need to provide more information and some context

      For example what is the Measure formula that produces the Balance figure?

      Also what additional fields are in the table/matrix (Visual that shows output)

      The sample data provided is not enough since it actually produces the correct result with a very simple sum measure