Forum Discussion

dphillips's avatar
dphillips
Icon for Helper IV rankHelper IV
7 years ago
Solved

Rank based on a measure

I have marks from students who have completed some tests. I have created a measure which gives me the average of the students results. Scld Mark Ave = AVERAGE(uncRedshift_Studentresults[Scld]) I h...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    dphillips add following measure for rank 

     

    Rank = 
RANKX( 
    FILTER( 
        ALL( Sheet1[FileYear], Sheet1[StudentYearLevel], Sheet1[StudentID] ),
        Sheet1[FileYear] = MAX(Sheet1[FileYear]) && 
        Sheet1[StudentYearLevel] = MAX( Sheet1[StudentYearLevel] )  
    ), 
    [Average Marks], , ASC, Dense
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

dphillips it should work, let me double check with slicer you mentioned in your message.

 

 

dphillips's avatar
dphillips
Icon for Helper IV rankHelper IV
7 years ago

parry2k - it does work great when in a table or matrix but my issue is I was trying to get this in a standalone card and create a sort of KPI for a student, rather than having a table with all  the students in it. Is this possible?

Thanks again for all your help.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    dphillips are you ok to share pbix instead me recreate everything at my end. Remove any sensitive it contains.

    • dphillips's avatar
      dphillips
      Icon for Helper IV rankHelper IV
      7 years ago

      Hey parry2k . Thanks so much for your help. I duplicated the page I was using, got rid of lots of slicers and filters to try and work out what was goin on and then started afresh on a new page and the card works properly on that page. Went back to the original page and, in the end, just got rid of the card and put a new card in, used the measure and all was fine. Again - thanks for all your help.