Ranking a table visulaisation that updates when slicer changes

[KTK]

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 ranking formula that calculates on the whole table (multiple learners can study multiple modules). What I want to be able to do is select a module in the slicer and the Student Ranking updates for the new selection so it restarts at 1, 2 etc rather than starting at 510, say.

The formulae I have used is:

Student Ranking = RANKX(FILTER(ALL('Student Scores'),'Student Scores'[Score %] <> BLANK()),'Student Scores'[Score %],,DESC,Dense)

Is this possible?

Thanks

[sevenhills]

Can you try this?

Student Ranking = RANKX(FILTER(ALLSELECTED('Student Scores'),'Student Scores'[Score %] <> BLANK()),'Student Scores'[Score %],,DESC,Dense)

[KTK]

Hi 

Thanks for replying. I have just tried it and filtered but the Student Ranking still starts from 171 rather than 1...

[sevenhills]

Ranking = RANKX(
             FILTER( ALLSELECTED('Student Scores'[Module], 'Student Scores'[Student Name])
                    , 'Student Scores'[Score %] <> BLANK())
    , [Score %],,DESC,Dense) 

How about this?

[KTK]

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 · Accepted solution]

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!