Make Table based on values that exist in 2nd table

Hi chakrared ,

According to your description, you want to get a summary table, right? Here are my steps you can follow as a solution.

(1) Create a relationship on the [All_Sites] table and the [Users] table.

(2)We can create  a table.

Summary Table = SELECTCOLUMNS( 'Users' , "Creator" , 'Users'[DisplayName] , "URL" , RELATED(All_Sites[URL]) ,"Files" , RELATED(All_Sites[Files]) , "Last Access" ,RELATED('All_Sites'[LastAccess]  ))

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.