Need help!!

Hi, guys! I need your help. I have 2 tables (Table with rights, table with users).

I know that i can connect them with power pivot many to many relationships by department and i can connect it with DAX formulas. I need to make report table where i can see who have access to any folder and what rights he has and in what department he work etc.

Please help me