The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[Anonymous]

hiii

i was using this formula to calculate waiting tym < 60 sec but its displaying an error

[v-kelly-msft]

Hi @Anonymous ,

If it is a measure ,modify it as below:

wait tym<60=Calculate(max('Phone Call Data'[waiting tym]),FILTER('Phone Call Data','Phone Call Data'[waiting tym]<TIME(0,0,60)))

 If it is a column,use below expression:

wait tym<60=IF('Phone Call Data'[waiting tym]<TIME(0,0,60),'Phone Call Data'[waiting tym],BLANK())

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak · Accepted solution]

@greeshma, if you try to create a column

then try to

flag: if([timeout] <time(0,1,0),1,0)

if measured then

measure- calculate(Sum(Table[wait time),filter(Table, Table[wait time] <time(0,1,0)))