Help needed for custom Yes/No measure involving a table that has multiple "Yes" and "No" results
I have the following tables Teams and Projects, they are related in a one to many relationship by Team Name:
What I want is to have a table visual that will have one row per team, with a custom column or measure that shows "Yes" if there is at least one project with "Yes" in the qualified column or "No" if there are no projects with "Yes". See below:
If I pull the Qualified Projects field (which is a custom column based on multiple criteria using the Switch function) I would get two rows for Team A, representing the two projects. I know I need some sort of If function probably.