Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

PowerBI Desktop

Hello PowerBI community      @Amit, @Greg , @tamerj1 , @lbendlin,   @amitchandak , @olgad , @Sahir_Maharaj , @FreemanZ , @tamerj1 , @Greg_Deckler    @christinepayton @audreygerred    @LukeB,...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

I guess you and I have a different understanding of what MTBF means.

 

Equipment A has failed three times.  That means it had two "times between failure".  MTBF can be computed by averaging each individual "time between failure"  or - simpler - by dividing the time from the earliest failure to the latest failure by two, resulting in 30.5 .  The "total operating time"  has no influence on the MTBF calculation.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello lbendlin 

 

Total Operating Time has direct relationship with Mean Time Between Failure. MTBF is the Total Operating Time/Number of Failures. 

 

Also, in the sample dataset, Equipment A has failed 3 times. Equipment B has also failed 3 times. So, the Number of Failures is equivalent to 3.

 

 

Please refer to the snapshot above. And we are trying to capture this in our DAX code. Can you please suggest an appropriate DAX code?

 

Thanks. 

  

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago