Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

none of them displays any value after being executed successfully

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

image.png

3 REPLIES 3
az38
Community Champion
Community Champion

Hi @Anonymous 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

hiii

image.pngimage.png

az38
Community Champion
Community Champion

@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)
)
 )

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.