none of them displays any value after being executed successfully

[Anonymous]

hiii guys

i have created and executed some queries created calculated measures for my data to cal culate waiting tym but none of them displays any value after being executed successfully. can some one help me i am working really hard for this

[az38]

Hi @Anonymous 

please, provide us any detail - data example, desired output and your incorrect measure

[Anonymous]

hiii

[az38]

@greeshma

sorry, I do not see [waiting tym] field in your screenshot,

try also

CALCULATE(COUNTROWS('Phone Call Data'), 'Phone Call Data'[waiting tym] < TIME(0,59,0) )

has a time format

or

= CALCULATE(COUNTROWS('Phone Call Data'), 
FILTER('Phone Call Data', 
TIME(
 HOUR('Phone Call Data'[waiting tym]),
 MINUTE('Phone Call Data'[waiting tym]),
 SECOND('Phone Call Data'[waiting tym])
)
 < TIME(0,59,0)
)
 )