Calculated column with filter on 2 different tables

Hi experts! I have a transactional table that shows me the sales for each article for each week. Now I would like to get the number of orders for each article. This is stored in a different table...