Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        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