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
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!