if statement time

[AI14]

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)

[tamerj1 · Accepted solution]

Hi @AI14 

try

test01 =

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

[AI14]

same result all showing 1 even uf its less or more

[tamerj1]

@AI14 

which column are you using to slice by in this table visual and from which table? 

[AI14]

worked, i added timevalue to both sections