Forum Discussion
Solved
Ranking a table visulaisation that updates when slicer changes
Hi, I hope someone can help as I have been looking at this for ages! I have created a table visualisation that shows modules, student names and their exam score. What I have then done is add a ranki...
Not sure why it is not working! All we are trying to do is get the value(s) of slicer and remove blanks and then rank!
Try one at a time and see
Ranking = RANKX( ALLSELECTED('Student Scores'[Module]), [Score %],,DESC,Dense) Ranking = RANKX( ALLSELECTED('Student Scores'[Student Name]), [Score %],,DESC,Dense) Ranking = RANKX( FILTER( ALLSELECTED('Student Scores'[Module]) , 'Student Scores'[Score %] <> BLANK()) , [Score %],,DESC,Dense) Ranking = RANKX( FILTER( ALLSELECTED( 'Student Scores'[Student Name]) , 'Student Scores'[Score %] <> BLANK()) , [Score %],,DESC,Dense)Ranking = RANKX( FILTER( ALLSELECTED('Student Scores'[Module], 'Student Scores'[Student Name]) , 'Student Scores'[Score %] <> BLANK()) , [Score %],,DESC,Dense)If not, pls share the data by removing sensitive info!
Hi,
Thanks for looking at this. That just gives 1's in the column. I'm thinking I need to go back to the source file and add rankings in there.
sevenhills
Super User
Super UserNot sure why it is not working! All we are trying to do is get the value(s) of slicer and remove blanks and then rank!
Try one at a time and see
Ranking = RANKX( ALLSELECTED('Student Scores'[Module]), [Score %],,DESC,Dense)
Ranking = RANKX( ALLSELECTED('Student Scores'[Student Name]), [Score %],,DESC,Dense)
Ranking = RANKX( FILTER( ALLSELECTED('Student Scores'[Module]) , 'Student Scores'[Score %] <> BLANK()) , [Score %],,DESC,Dense)
Ranking = RANKX( FILTER( ALLSELECTED( 'Student Scores'[Student Name]) , 'Student Scores'[Score %] <> BLANK()) , [Score %],,DESC,Dense)
Ranking = RANKX(
FILTER( ALLSELECTED('Student Scores'[Module], 'Student Scores'[Student Name])
, 'Student Scores'[Score %] <> BLANK())
, [Score %],,DESC,Dense)
If not, pls share the data by removing sensitive info!