I have a list of students that I’d like to filter based on grade level and/or room. I’m using quick edit buttons for grade (M1 - M6) and rooms (101, 102, 103, 201, 202, 203, …). The slice is set up and working the way I want when a grade or room is selected. It’s the buttons that are not working properly.
I’m using a Valid If expression to only show the rooms in a selected grade level:
SELECT( Rooms[RoomNumber] , [GradeLevel] = RIGHT( ANY(SELECT ( Filters[GradeLevelFilter] , USEREMAIL() = [Email] )) , 1) )
The Valid If expression is working as seen here with only the M3 rooms showing when M3 is selected:
The problem occurs when I select a room and then select a different grade level. For example if I select 301 and then select a different grade level such as M2, the room buttons will change once, but then they get stuck and won’t change no matter which grade button I select. As you can see here I have M1 selected but the rooms are stuck on the M2 rooms and I get the red invalid error message.
Ideally I would like to clear the RoomFilter column if a different grade level is selected. If that’s not possible, I don’t mind if a selected room and grade level don’t match (I can set up the slice to give preference to the grade level), but I’ll need the room buttons to change to match the selected grade levels.
Thanks in advance!