Calculated Column not Working in a Certain Condition

[utsavlexmark]

AWS Flag = IF(SUMX('Table Name',[Measure]+[Measure 1]+[Measure 2]+[Measure 3]+'Table Name'[Column Name])/4>0,"Y","N")

This is the calculated column that is creating problem. as per condition if the result of the calculation is greater than "0" it will show "Y" and if the result is either "0" or les than 0 then it will be "N".

The problem is the 2nd condition is not working if all 4 Measures and the column are having "0" value.

Can anyone suggest what to do in such condition?

I am not sure what more information required for a solution - please let me know if anyone need any more info to suggest.

Regards

Utsav

[v-xicai · Accepted solution]

Hi @utsavlexmark ,

You can try to create column like DAX below.

AWS Flag =
Var d=AND(ISBLANK([Measure]),ISBLANK([Measure1]),ISBLANK([Measure2]),ISBLANK([Measure3]),ISBLANK('Table Name'[Column Name]))
Return
IF(d=TRUE(), "N", IF(SUMX('Table Name',[Measure]+[Measure 1]+[Measure 2]+[Measure 3]+'Table Name'[Column Name])/4>0,"Y","N"))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.