Forum Discussion

KTK's avatar
KTK
Frequent Visitor
2 years ago
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...
Need Help
  • sevenhills's avatar
    sevenhills
    2 years ago

    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!

     

sevenhills's avatar
sevenhills
Super User
2 years ago

Can you try this?

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

KTK's avatar
KTK
Frequent Visitor
2 years ago

Hi 

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

 

 

  • sevenhills's avatar
    sevenhills
    Super User
    2 years ago
    Ranking = RANKX(
             FILTER( ALLSELECTED('Student Scores'[Module], 'Student Scores'[Student Name])
                    , 'Student Scores'[Score %] <> BLANK())
    , [Score %],,DESC,Dense)

     

    How about this?

    • KTK's avatar
      KTK
      Frequent Visitor
      2 years ago

      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's avatar
        sevenhills
        Super User
        2 years ago

        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!