Rank with two categories - help please

Question

Hi everyone,&nbsp;I have a table with student name, subject, exam type and exam grade. I would like to create a rank measure/column that ranks each pupils exam grades by exam type.&nbsp;&nbsp;If two grades are the same the rank value needs to be consecutive e.g. Student 1, exam grade 9 = 1, exam grade 9 = 2, exam grade 8 = 3 and so on.&nbsp;I think this screenshot helps explain what I am trying to do more clearly:Screenshot&nbsp;I've had a few attempts at RankX but can't get the correct result!&nbsp;&nbsp;Thanks for any help!Matt&nbsp;

ashish_mathur · Answer

Hi,
Share the link from where i can download your PBI file.

anonymous · Answer

Hi there,&nbsp;&nbsp;Thanks for offering your help. I've cleaned all the data but I'm pretty sure everything that is required is in there.Example data - PBI file&nbsp;Thanks again.Matt

ashish_mathur · Answer

Hi,
I am confused.&nbsp; In your original screenshot, there was a simple Table.&nbsp; In your PBI file, there is a matrix.&nbsp; In the matrix, where do youw ant to see the rank.&nbsp; Be as clear as possible for me to assist you.

anonymous · Answer

Hi Ashish, Sorry about the confusion - I've removed the matrix and added in an example output matrix of how I would like the data to appear. This uses three measures that calculate the sum of each rank which are used in the matrix. What I don't know how to do is turn to add a new column to the Exam data table that ranks each pupil's exam results by exam type. I'm not sure if it's relevant by the Name field comes from a related table. Thanks for your help. Matt

ashish_mathur · Answer

Hi,
When i download the PBI file from that link, i still see the same matrix and there is no measure that you have written in that file.

Forum Discussion

Rank with two categories - help please

7 Replies

Related content

RANK by category?

Ranking by category

Ranking Sales By Multiple Categories

Duplicate ranking

Ranking KPI card