calculate waiting tym <30sec and <60 sec

[Anonymous]

hiiii

i want to display all the columns with waiting tym < 30sec as one table and < 60sec in another table using dax operations

[v-eqin-msft]

Hi @Anonymous ,

According to my understanding, you want count the rows where the waiting time is <60s,right?

You could following the steps:

1.Set the waiting time column (as your data sample shown) as "Time",than format it.

2.Add a new table using formula like this:

wait tym < 60 =
FILTER ( 'Wait', 'Wait'[waiting tym] < TIME ( 0, 0, 60 ) )

3.Create a measure to count rows:

Countrows =
COUNTROWS ( ALL ( 'wait tym < 60' ) )

Then the visual looks like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

As @FrankAT  said, you could use Time(Hour,Minute,Second) to calculate the value. 

In addition, it is important to note that the waiting time's data type should be Time and then format it as follows:

Best regards,

Eyelyn Qin

[Anonymous]

hiii eleyn

i tried applying those things but the output is not been in sec its showing as 00:00:00 for all the columns

this is the formula i applied

wait tym < 60 = COUNTROWS(FILTER('Phone Call Data','Phone Call Data'[Wait Time]< TIME(0,0,30)))

[FrankAT]

Hi @Anonymous 

take a look at the following solution:

 Regards FrankAT