Recreating SUMIFS formula with Calculate and FILTERS, so that conditions can equal values in rows
I'm trying to create a new column in Table 2 in Power BI (example below already has the columns..), by taking the Revenue from the Details table, by not using a Measure. I have way too many Clients to write a condition for every client, so need a IF/FILTER or another function to serve this purpose similar to a SUMIFS in excel. So that if my table changes clients/affiliation, the revenue would adjust with it.
This is the current formula I have, but it obviously doesn't work.