Rank with two categories - help please

[CorkeMP]

Hi everyone,

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. 

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.

I think this screenshot helps explain what I am trying to do more clearly:

Screenshot

I've had a few attempts at RankX but can't get the correct result! 

Thanks for any help!

Matt

[Ashish_Mathur]

Hi,

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

[CorkeMP]

Hi there, 

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

Thanks again.

Matt

[Ashish_Mathur]

Hi,

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

[CorkeMP]

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]

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.

[CorkeMP]

VPN issues - the file has synced now.

Thanks

Matt

[Ashish_Mathur]

Hi,

Does this work?