Can you separate the comma-separated list into individual rows? I believe that would make your problem much easier to solve. There may still be a solution, but I'm not 100% at a first glance. Happy analyzing!
Create a parameter, title it "Choose a Major", make it a string, select list, enter all the available majors
Create calculated field: CONTAINS([Major], [My Parameter])
Right-click the parameter and select 'Show Parameter Control' - it should be a dropdown with all the majors you just listed
Drag your calculated field to filter and select True
You should be good to go
Thanks a lot for your reply! I did as your instruction and it worked! But the parameter only allows me to select one major at a time. Is there any possibility that I could have multiple selections so that I can filter school with all the majors or any of these majors.
Unfortunately parameters only work with single selection.
Your best bet is to reshape your data with a single column for major and the university is repeated. Then a separate table with just the names of universities and link the two tables on university