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 study with the decimal number and fixed decimal number.

 

Then I change my amount column to fixed-decimal-number type, it solved.

 

But I still want to know why the number is different between the MYSQL database and power bi desktop.

 

Aiolos Zhao
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi danextian,

     

    Sorry for reply late and thanks for your reply.

     

    Yes, I'm using the double(10,2) in my MYSQL database for this column, so I think it won't be the MYSQL problem.

     

    And I saw the link you mentions, do you think it is a bug of Power BI about precision decimal?

     

    For now, I can use "Change Type to decimal number" to solve this problem.

     

    Thanks.

    Aiolos Zhao