Isolating a multiple choice response inside a collumn

Hi inickqc 

I made a copy of the data to my drive, I couldn't connect to your drive. 

I made the following steps

• Imported through the Google Sheets connector
• I promoted the Programms as the columns headers
• Removed the last two columns
• Highlighted all columns and unpivoted them.
• I removed some text from the Program names
• I also removed the .1 & .2 at the end of each program name

I loaded the data in and created the below example for you to check

https://drive.google.com/file/d/1gshoL7z6WVDxSKdeHvRBdxlJ2wgWFNvf/view?usp=sharing 

Before loading the data, remove this relationship in the Model view for all tables that are linked to it. After loading in, create the relationships again. This time they will be Many to Many. Change the Cross Filter Direction to what you need