New Column, like SUMIFS with multiple matching columns

[nbrandborg]

Hi all,

I really struggle to make a needed SUM column which is based on multiple criterias one of them being a Date/Month-column.
My dataset looks like this:

The two yellow marked columns are criterias it needs to match together, the Blue one has to be equal to "P" and Green is what it needs to SUM ultimately in the column I have on the far right.

I hope it makes sense?

Best regards!

[nbrandborg]

Thanks! It worked like intended!

[Anonymous · Accepted solution]

@nbrandborg So basically you want to calculate the SUM(REUnits) by month year for each country where companysalesrating = "P"

You can use the below Query to create a calculated column

CALCULATE(SUM(REUnits), FILTER(ALLEXCEPT(TABLE, TABLE[MONTH YEAR], TABLE[COUNTRY],TABLE[ComanySalesRating]), TABLE[CompanySalesrating] = "P"))

let me know if that helps.