About sorting data

[Anonymous]

hi all

I had a problem writing RANKX . so here's my RANKX function

     totalCount = SUM(Table1[count])

     countRAN = RANKX(ALL(Table1[time]),[totalCount],,ASC)

But here's what I got

The first image is the result of my table, and the second image is my data

You can see in the first picture that my RANKX function calculated something wrong with the data

Can someone tell me why  thinks

Best Regards

alan-li

[Anonymous · Accepted solution]

Create a calculated column 
RankCount  = RANKX(Table,Table[count])

[Anonymous]

hi @Anonymous 

It works. Thank you

Best Regards

alan-li