Column Subtotals Not Calculating Correctly

Hi!

I know this is a popular topic but I can't find the solution anywhere. I have two data tables that are directly unrelated (1 for sales and 1 for expenses). They connected indirectly, however. Both to the date table on their dates and to a Market Table by store number.

I want to only include sales if there is a value in the expense for each day and market.

My formula is as follows:

ROI Catering Sales = 

IF(
    SUM('New Table'[Daily Total Pay])<=0
    ,BLANK()
    ,SUM('Daily Reporting'[OM Catering Net Sales])
)

When I bring this to a matrix it seems to be summing correctly for the months, but the totals aren't summing correctly It is summing the total sales for the full year.

I've tried a series of SUMX combinations but haven't had any luck...I don't think I can do it without the values both being in thge same table?

Here is a picture of the visual.

Any help would be GREATLY appreciated!! : )