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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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