Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Why do the same values have different rank number?

Hi all,   I find a strange thing in my report. I have ID, expenses, and rank. The ID column is just a column value, The Expenses column is a sum of amount, not a measure. RANK = RANKX(ALL(DiDi[e...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have grouped by id, month, and type to sum amount. (Reduce order id)

 

Now the table only has around 30,000 rows, but the result is also wrong.

 

Aiolos Zhao

danextian's avatar
danextian
Icon for Super User rankSuper User
6 years ago

Hi  , 

Have you tried creating  a checker formula to determine if indeed your measure returns a flat 2500 for each ID? You can tryChecker = [Measure] = 2500which will return true/false. It could be that your 2500 is actually 2500.00000000012121. 

 

Is your ID being sorted by another column? If it is, the sort by column should be included in your RANKX argument. 

Rank =
RANKX ( ALL ( 'Table'[ID], 'Table'[SortBy] ), [Sum of Values],, DESC, SKIP )

 

 

 

Anonymous

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi danextian,

     

    Thanks for your reply. I use the checker like you said, it works.

     

    But now I wonder why the number is ......02, in the database, I'm using MySQL, the type of amount column is double(10,2), the value is 52.99.

     

    But after I loaded into power bi, it change to 52.99........02.

     

    Aiolos Zhao