Forum Discussion

ssvr's avatar
ssvr
Helper III
8 years ago
Solved

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") -- T...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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