Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter Table By Score

Hi I am trying to filter a table by a score (measure)

Say select a student B and his score is 60 I would like the table to bring back all of the students that have the same score;

 

Any help will be great.

 

Thanks

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous  This could be a possible workaround:

     

    Create the above visuals and edit interaction of Student Fi;ter and Table. 

     

    - Now when you select a student, the mark is going to be highlighted in the card, but the table values would not change as you have editted interaction. ( At the same time your score filter would change)

    - Now select 60 in the slicer and then the table would give you a list of students in that score.

     

     

     

    * *Just a workaround, and they would all make better sense if the visuals are arranged accordingly with proper headers (Say select a student of your choice and then a score)

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hey Anonymous 

     

    could you show how score is calculated?

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Student Score

      Student A50
      Student B60
      Student C60
      Student D60

       

      And the end result would be like below;

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous  This could be a possible workaround:

         

        Create the above visuals and edit interaction of Student Fi;ter and Table. 

         

        - Now when you select a student, the mark is going to be highlighted in the card, but the table values would not change as you have editted interaction. ( At the same time your score filter would change)

        - Now select 60 in the slicer and then the table would give you a list of students in that score.

         

         

         

        * *Just a workaround, and they would all make better sense if the visuals are arranged accordingly with proper headers (Say select a student of your choice and then a score)