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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.