SUM IF to DAX

[ariass]

Hey everyone,

I'm trying to create a column that gets me the amount of phone calls since the last sale for each sales rep. I have a table with a Rep column and Date of Last Sale column. I'm having an issue trying to sum from my phone call table only if the Date of Call is after the Date of Last Sale. My thought was to create a measure using sumif and then a column in the Sales Rep table based off that measure. SUMIF(Date of Call,>Date of Last Call,Phone Call Count) would be my formula in excel but I need help going to DAX.

[Greg_Deckler · Accepted solution]

Generally the answer to SUMIF questions is CALCULATE. So, something like:

Measure = CALCULATE(SUM(Table[Column]),FILTER(...))

The FILTER essentially becomes the "IF" portion of your SUMIF.