Ranking Issues

Question

Hi All,&nbsp;I've been trying out examples in previous posts, but I don't seem to have found the solution to my Ranking issue.&nbsp;&nbsp;My data looks line like the following&nbsp;ID&nbsp; &nbsp;Person&nbsp; &nbsp; &nbsp;Period&nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp; Mark1&nbsp; &nbsp; &nbsp;Bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp;Andy&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp;Matt&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; 31&nbsp; &nbsp; &nbsp;Jon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01&nbsp; &nbsp; &nbsp;Bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp;Andy&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; 31&nbsp; &nbsp; &nbsp;Matt&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; Jon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 01&nbsp; &nbsp; &nbsp;Bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp;Andy&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; 31&nbsp; &nbsp; &nbsp;Matt&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp;Jon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01&nbsp; &nbsp; &nbsp;Bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; 31&nbsp; &nbsp; &nbsp;Andy&nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp;Matt&nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 190&nbsp; &nbsp; &nbsp;21&nbsp; &nbsp; &nbsp;Jon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;The end result would be I'm looking for is the following,&nbsp;there would then be ID 2, ID 3 all with different figures&nbsp;but all with different rankings for them.&nbsp;&nbsp;&nbsp;Person&nbsp; &nbsp; &nbsp; Rank&nbsp; &nbsp; &nbsp;Total Mark&nbsp; &nbsp; Total ValueMatt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;690Andy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;650Bob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500Jon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;&nbsp;&nbsp;The issues I have is that at the moment all my rankings show as 1 or some other random number.&nbsp;

petrovnikitamai · Accepted Answer

i'm not sure to understand u but try thisif u want to get the tableuse this queryrank = 
var total = SUMMARIZE(tableName;[Person];"Total Mark";SUM(tableName[Mark]);"Total Value";SUM(tableName[Value]))
return 
ADDCOLUMNS(total;"rank";RANKX(total;[Total Value];;DESC;Dense))&nbsp;

Forum Discussion

Ranking Issues

1 Reply

Related content

DAX Ranking Issue

Rank Issue - Table vs Filter Results

Duplicate ranking

Ranking issue

Ranking issue