Forum Discussion
Helper IVRank based on a measure
Super Userdphillips 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
)
Helper IVparry2k - Thanks for the info. I keep getting a rank of 1 for any student I select. Have looked at your measure and tested filters, and the aggregations used, substituted in actual values etc, but I still always get a rank of 1 no matter which student I select. Any thoughts about what I am doing wrong? This is my measure for getting the average scaled mark for a student.
Average Marks = AVERAGE([ScldMark])
I then have slicers on the page for Fileyear, StudentYearLevel and StudentID.
I want this to be displayed in a card on its own.
Perhaps the problem is that this needs to be in a table or matrix so it can rank against the other values in the visual. If that is the case, how can I get this to be a standalone rank in a card? (Just tested this theory in a table and found that your measure works great - everything correct - thanks so much - but as I said - I want to try and create a kpi matrix which uses a card with just the rank for that one student)
Any thoughts?