My workbook explains it better but say that I have a group of people, their scores, and the dates they got the scores on. I want to be able to have a graph that displays the names of only the people who only got 1's and 2's as their scores.
In other words, if someone even got a 3,4, or 5, such as Jasmine, Bella, and Timmy did in this dataset, I want to be able to just remove all of their entries from consideration and display just the other names that never got below a 2 for their scores. I would appreciate any help in being able to do this! Thank you!
You can use a FIXED Level of Detail (LoD) function to get the maximum score for each user. That value is then on each row of data, so you can convert it to a Dimension and it becomes a characteristic on which you can filter.
{FIXED [Name]:MAX([Score])}Create that calculated field, then right-click on it and select "Convert to Dimension". You can then drag it to the filters and select 1 and 2.
