Forum Discussion
DAX IF formula - New Measure
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
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
1 Reply
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