User/Team Security Matrix

[wlknsnBI]

Hi All,

I'm trying to create a security matrix between users and their respective roles. However, the complexity is that the user can be part of a team which also has roles. That means that role also is applied to the related user of that team.

So the goals is to have a matrix between users and security roles with a measure which counts the amount of roles related to the respective users. Any advice on this measure would be very welcome!

[Icey]

Hi @wlknsnBI ,

I create a model like below, but it can't work well. Please share me your PBIX file without sensitive information.

Best Regards,

Icey