Filter Table By Score

[Anonymous]

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]

Hey @Anonymous 

could you show how score is calculated?

[Anonymous]

Student Score

Student A	50
Student B	60
Student C	60
Student D	60

And the end result would be like below;

[Anonymous · Accepted solution]

@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)

[Anonymous]

Hi @Anonymous 

Yep this is kinda the first route that i went down, but really they want it in one click ( you know what users are like).

But i am unsure if there is a solution as you are unable to have a measure directly in the visual.

Thanks