Forum Discussion
Rank with two categories - help please
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 ...
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.
Thanks again.
Matt
Ashish_Mathur
Super User
Super UserHi,
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.
- 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.
VPN issues - the file has synced now.
Thanks
Matt