Showing results for 
Search instead for 
Did you mean: 

Mean Time Between Failure (MTBF)

Super User
Super User
Super User

Mean Time Between Failure (MTBF)

This Quick Measure is an update to my Mean Time Between Failure (MTBF) measure that I developed in this article:


The original method had some significant column-based elements and my goal was to make this measure truly dynamic. A significant issue with the original approach is that when slicing by "Cause", the MTBF figure calculated was not truly dynamic by Cause of failure. In other words, the Uptime calculation did not account for only looking at particular causes, only between failures of the same machine. So, uptime calculated by considering all causes is vastly different than when only looking at a particular cause. 


This measure corrects that flaw, although I have also included a version of the measure that does not need a calculated column but calculates uptime in the exact same way as in the aforementioned article. The new measures are down in the bottom, right-hand corner. You will notice that the new fully dynamic measure is much larger when selecting a Cause. This is because the MTBF calculation is only considering the MTBF for that particular cause.



MTBF (Hours) Measure = 
VAR __table = 'Repairs'
VAR __table1 = 
                            [MachineName]=EARLIER([MachineName]) && 
                            [RepairStarted]>EARLIER([RepairStarted]) && 
VAR __table2 = ADDCOLUMNS(__table1,"__uptime",
VAR __repairs = CALCULATE(COUNTROWS('Repairs'),FILTER(ALLSELECTED('Repairs'),[RepairType]<>"PM"))



I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

evboczar Frequent Visitor
Frequent Visitor

Re: Mean Time Between Failure (MTBF)

Im struggling with some points:

  • What about visualizing the MTBF during days, weeks or months? I mean, to check out if the value is correct, I would like to filter it by day, check the calculations by hand and then comparing it with the measure, but the values are very wierd. How could w solve that? What about a visual showing how the MTBF is developing?


I really need this and your post is the only one I found that gets closer to my issue.