total downtime of machine

[sabi_9]

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. 

[Greg_Deckler · Accepted solution]

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.

[Anonymous]

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