SUMIF Equivalent in Power BI

[dti]

I have two unrelated tables that I am trying to perform a simple SUMIF calcluation on. I can easily do this in Microsoft Excel but am struggling to get it completed in Power BI. The simplified scenario is described below. Both tables in my Power BI model are loaded using DirectQuery.

Table1: Sales Summary

     Column B: Equivalent Payroll Finish Date

     Column C: Revenue

Table2: Payroll

     Column B: Payroll Finish Date

     Column C: Payroll Amount

     Column E (Calculated): Same Finish Date Revenue

In 'Table2 [Column E]' I'm trying to calculate the total revenue for the same payroll finish date listed in Table1. This is easily completed in excel using the following formula: "=SUMIF('Sales Summary'!$B$3:$B$7,Payroll!B3,'Sales Summary'!$C$3:$C$7)"

How could I go about completing this in Power BI? I can't get the "CALCULATE(SUM..." function to filter properly.

Thank you for any help as I've been working on this for a couple days now!