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
Stan914
Regular Visitor

Power BI

I'm working on a dashboard with 3 columns I needed which is wait time, state, in network. I want to figure out the avereage wait time people had to wait to see the doctor. How can I accomplish that? 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi  ,

Pls refer the below:

average = FORMAT(AVERAGEX(FILTER(ALL('Table'),'Table'[Column4]="N"),'Table'[Column3]),"HH:NN:SS") 

 vluwangmsft_1-1670232972123.png

 

 

View solution in original post

5 REPLIES 5
v-luwang-msft
Community Support
Community Support

Hi  ,

Pls refer the below:

average = FORMAT(AVERAGEX(FILTER(ALL('Table'),'Table'[Column4]="N"),'Table'[Column3]),"HH:NN:SS") 

 vluwangmsft_1-1670232972123.png

 

 

Hey that didn't work for me.. when I try to add the new measure to the table it says can't display the visual how can I go about that?

Hi @Stan914 ,

Please check your column types to keep them consistent with the ones in my sample.

 

 

Best Regards

Lucien

Hey I was able to figure it out with the average function thanks. I'm trying to find the count of wait times above 5 minutes how can I accomplish that? The count is in seconds

lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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.

Top Solution Authors