output display in a column

[Anonymous]

hiii i have used a query to filter the waiting tym < 60 secs from waiting tym column.now i want to display them in a column but the query is been executed but not showing any result in the column.

wait < 60 sec = (COUNTROWS(FILTER( 'Phone Call Data','Phone Call Data'[waiting tym] < TIME(0,1,0))))

[V-lianl-msft]

Hi @Anonymous ,

From the formula you provided, I found nothing wrong. Is measure or column created? If it is measure, then it is related to the current context of measure.

If the problem persists,could you share the sample pbix or sample data?

Please mask any sensitive data before uploading

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

[harshnathani]

HI @Anonymous ,

What is the format of the waiting tym column

See what Time returns

https://dax.guide/time/

Try this

wait < 60 sec =
 (
    COUNTROWS (
        FILTER (
            'Phone Call Data',
            'Phone Call Data'[waiting tym]
                < TIME ( 0, 59, 0 )
        )
    )
)

Regards,

Harsh Nathani