Forum Discussion
Smits474
9 years agoFrequent Visitor
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...
MattAllington
Community Champion
9 years agosorry, that was a silly mistake. Try this
Rank = rankx(all(data[Name]),CALCULATE(max(data[Speed])))
Smits474
9 years agoFrequent Visitor
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?
- MattAllington9 years ago
Community Champion
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.