Show all associated rows depending on a specific column filter

[S_Murphy]

I have played around with several options before coming here for what I'm sure will be an answer in half the time...

I've got a table of all the company staff and their qualifications. I need to filter this only to show my staff which will have the exclusive qualification of Swim Instructor in the system. However, there are a number of qualifications that all staff will need and so it's not possible to filter by just a couple of options specific to my team.

So I'm needing:
- Filter for anyone who has Swim Instructor qualification
- AND see all other qualifications that they will have that might be shared with others (eg. CPR is needed by all other staff, but I don't want to see the other staff with this, just the CPR qual for my team).

Hope that rambling makes sense. Let me know if more info is needed.

[parry2k]

@S_Murphy check if this video help on my YT channel: https://youtu.be/zS1IDl3DLak

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️