DAX IF formula - New Measure

[ssvr]

Hi Team, 

I required the IF formula for (New Measure) 

Find the attachment for your reference

DDiff_SLA(RtDt) = IF([DDiffRelCloDT] <= [DDiff_RelDateDueDate], "Met SLA", "NotMet SLA") -- This formula is not works

[v-yuezhe-msft · Accepted solution]

@ssvr,

Based on my test, the formula that you offered could only be used in calculate column. So when you want to create a measure using it, it will not work.

So, to create a measure, we can use the sum function in your formula.

RtDt Measure := IF(SUM(Table1[DDiffRelCloDT]) <= SUM(Table1[DDiff_RelDateDueDate]) ,"Met SLA", "NotMet SLA")

Also we can get the same result as the calculated column. Please refer to the picture as below:

 

For more information, please check the pbix as attached.

Regards,
Lydia