Forum Discussion

S_Murphy's avatar
S_Murphy
New Member
3 years ago

Show all associated rows depending on a specific column filter

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.

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    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! ❤️