Forum Discussion

Smits474's avatar
Smits474
Frequent Visitor
9 years ago

Rank with the actual values

Hey Guys,   I want to rank the name of persons. An example is given below. I have different people with different types and different speeds on different dates and times. I want to know which per...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

I'm not on my PC, but from memory. 

 

Add a slicer and select one of the types

Create a table and add the names

write a measure like this. 

 

Rank = rankx(all(tablename[name]),max(tablename[speed])). This should give the order (i.e. Rank). 

If you just want the speed, just use

=max(tablename[speed]) 

Smits474's avatar
Smits474
Frequent Visitor
9 years ago

When i use this rank, it only gives all the different persons rank 1

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    9 years ago

    sorry, that was a silly mistake.  Try this

     

    Rank = rankx(all(data[Name]),CALCULATE(max(data[Speed])))

    • Smits474's avatar
      Smits474
      Frequent Visitor
      9 years ago

      Same problem. And i only get the values of the person who is selected in my slicer, but i want all the other persons too. Maybe the top n function is better to use?

      • MattAllington's avatar
        MattAllington
        Icon for Community Champion rankCommunity Champion
        9 years ago

        I tested this measure. If you put people on rows of a table, and a slicer on the type, it will give you the rank for each person.