Use selection to filter table, use associated result to filter separate table visual

Hi there,

I got the following data:

Now I want to do the following:

1. Select an authorisation_id, for example: 2
2. Take the resulting identity_id's: 3 & 4
3. Show a table of all the roles these identity_id's (3 & 4) have, so in this case role_id's: 1003 and 1005

The problem I am running into, is that when I select an authorisation_id in a table in my report, it automatically filters role_id as well. I know I can prevent this by going to format -> edit interactions -> None on my role_id table visual. But this gives me all the role_id's, even the ones not associated with the identity_id's that have the selected authorisation_id. I tried solving this with some dax with calculated measures/columns so it gives a TRUE/FALSE based on if the role_id has one of the selected identity_id's, but I just can't make sense of it and neither can CoPilot etc.

So I am looking for a way to answer this question:
How can I show all the role_id's associated with the identity_id's that have the current selected authorisation_id.

Any help is appreciated and if you need any more info please let me know.