Group By using DAX with column in another table

[akhaliq7]

I need to aggregate two columns and then do a group by from a column in another table using DAX

p.s. department is in another table

count(id), avg(delivery_duration), department

below is the tables and columns

sales[id], sales[delivery_duration], users[department]

[amitchandak · Accepted solution]

@akhaliq7 , These two tables should have some relationship. otherwise , it  will show the same value for all departments