Forum Discussion

alexa_0028's avatar
alexa_0028
Resolver II
4 years ago
Solved

RankX is missing ranks

Hi All,

I am trying to write a simple RankX measure but my ranks are not correct. As you can see in the screenshot below.

 

 

The measure I am using is :

Rank =
IF (HASONEVALUE('C Account'[C. Parent Account]),
RANKX(CALCULATETABLE(VALUES('C Account'[C. Parent Account]),ALLSELECTED('C Account'[C. Parent Account])),[Invoiced Sales (IS)],,,Dense))

I have tried everything but still it is not working.
Please help me
Need Help
  • alexa_0028's avatar
    alexa_0028
    4 years ago

    Hi All, my issue got resolved when I changed the data type of my measure to the whole number instead of decimal.
    It seems like a bug in PBI. 

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    alexa_0028 , remove hasonevalue and check

    Try Like

    RANKX(ALLSELECTED('C Account'[C. Parent Account]),[Invoiced Sales (IS)],,desc,Dense)

  • alexa_0028's avatar
    alexa_0028
    Resolver II
    4 years ago

    Hi All, my issue got resolved when I changed the data type of my measure to the whole number instead of decimal.
    It seems like a bug in PBI.