DAX for Calculating Mean Time for certain conditions

[sanchar123]

HI Team,

I have a condition where the DateTime stamp is not periodic and Pressure should be in the range of 2000< Pressure < 4000

I have the desired calculations explained in the attached figure. 

Raw data is with the time stamp and pressure values.

I have to calculate the Mean Time between Failures (good data duration) = MTBF

 Mean TIme  to restore Services (bad data duration)= MTTS 

Can you please let me putting the logic.

Thanks in advance.

[YukiK]

I'm not sure if I correctly understand the requirement, but you can probably do something like the following for MTBF to work.

1. Pressure within range = CALCULATE(SUM(Pressure), AND(Pressure >2000, Pressure < 4000))

2. MTBF = AVERAGEX(VALUES(Date), [Pressure within range])

2 is assuming that you have a date column whose grain is per row per day.

Hope this helps!

[sanchar123]

Thanks for the reply. although i am not really getting your logic applied.