DAX function that acts as SUMIF

[Anonymous]

Hello,

I want to create a column in one table that first checks to see if two values match, and thens Sums the corresponding values in the new column.  In this case I would be checking to see if the counties match, and then summing the corresponding values. 

Here are the two tables I am working with. 

So in the end I want to Match CountyS with county Name, and then sum the values from WP_Plant into a new column matching the respective county. Any help would be greatly appreciated. Thank you.

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

I assume you want to add the colmn to the second table?  If they are joined from 'Table1'[County Name] to 'Table2'[CountyS] the you can do by adding a column in Table 2 with this measure.

CALCULATE( SUM ( Table1[WP_Plant] ), RELATEDTABLE( Table1 ) )

[Anonymous]

Hi @Anonymous 

Please provide the data in a way we could copy&paste it. Or attach your PBIX file.

Also, please provide the expected results.

Thanks!
A