Hi my measure doesnt seem to work. i want to show a 1 if the task duration is less than the clean sla. Task duarion is a measure that does outbound_st - sta & Clean SLA is a column i manually added times for each reg. test01 = IF( [TaskDuration] < SUMX(clean,clean[Clean SLA]),1)

Hi AI14 try test01 = IF( TIMEVALUE ( [TaskDuration] ) < SUMX(clean,clean[Clean SLA]),1)

Forum Discussion

Helper III

3 years ago

Solved

my measure doesnt seem to work. i want to show a 1 if the task duration is less than the clean sla.

Task duarion is a measure that does outbound_st - sta & Clean SLA is a column i manually added times for each reg.

test01 =

IF( [TaskDuration] < SUMX(clean,clean[Clean SLA]),1)