cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sabi_9
Frequent Visitor

total downtime of machine

Untitled.pngUntitled2.png

I want to calculate total downtime of machine by machine status. if i select any machine name it has to show the total downtime of taht machine accordingly for example in the form of  1(day):23:5:5. Can anyone tell what should i do to calculate the downtime. 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Take a look at my article on MTBF. I think that it will greatly assist you. Also, take a look at my article on aggregating duration.

 

https://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339...

 

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

 

I think there is also a quick measure or two in the Gallery related to duration.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Take a look at my article on MTBF. I think that it will greatly assist you. Also, take a look at my article on aggregating duration.

 

https://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339...

 

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

 

I think there is also a quick measure or two in the Gallery related to duration.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

How can this be extended to report the line (with multiple equipment) and area(with multiple lines) Uptimes. For example:

Serial line : If a line has 4 machines , the lowest of the 4 should be the line Uptime 

Parallel line : all 4 equipment running in parallel : Average of all 4 machines should be line Uptime

Since the filter context for a unit would be only for taht unit , the line and area uptimes would be same as equipment uptime...any help would be appreaciated

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors