Forum Discussion

JonathanJohns's avatar
JonathanJohns
Helper III
8 years ago
Solved

Ranking calculation in a table

Good morning,   I have a problem with a calculation. I want to do a PARETO Chart. I used the tutorial at this address : https://powerbi.tips/2016/10/pareto-charting/   But when I do it, it doesn'...
Need Help
  • iamprajot's avatar
    iamprajot
    8 years ago

    Create an additional column that is different from the similar Sales Column

    SupportCol = Data[Sales]+(RANDBETWEEN(1,100)/10000000)

    This will add decimal value to the similar numbers hence making it non similar.

    Then do the ranking based on this SupportCol

    RANKX(TableName,[SupportCol],,DESC)

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago

The problem is the ranking, it is giving same Ranks for two similar figures.

I have tried to find it out but couldn't succed in getting a good solution for Ranking of same figures.

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago

Create an additional column that is different from the similar Sales Column

SupportCol = Data[Sales]+(RANDBETWEEN(1,100)/10000000)

This will add decimal value to the similar numbers hence making it non similar.

Then do the ranking based on this SupportCol

RANKX(TableName,[SupportCol],,DESC)

  • JonathanJohns's avatar
    JonathanJohns
    Helper III
    8 years ago

    Thank you it looks working. :)

  • AliceW's avatar
    AliceW
    Power Participant
    5 years ago

    It works! Thank you SO MUCH!!