Skip to content
Smith Lino Moreno
Back to blog

How to calculate MTBF, MTTR and availability in Power BI with SAP PM data

A practical guide to building an asset-reliability dashboard in Power BI: data model, DAX measures and best practices.

Smith Eusebio Lino Moreno, Power BI, 1 min read

Reliability KPIs are the common language between maintenance and management. The problem: in most plants the data lives in SAP PM exports that nobody joins in time.

1. The data model

Use a star schema:

  • FactOrders: one row per work order (asset, type, start, end, cost).
  • FactNotifications: one row per failure notification.
  • DimAsset, DimDate, DimMaintenanceType.

One-to-many relationships from dimensions, single-direction filtering.

2. Essential DAX measures

Downtime Hours =
SUMX ( FactOrders, DATEDIFF ( FactOrders[Start], FactOrders[End], MINUTE ) / 60 )

Failures = COUNTROWS ( FILTER ( FactNotifications, FactNotifications[Type] = "Corrective" ) )

MTTR (h) = DIVIDE ( [Downtime Hours], [Failures] )

MTBF (h) = DIVIDE ( [Operating Hours] - [Downtime Hours], [Failures] )

Availability % = DIVIDE ( [MTBF (h)], [MTBF (h)] + [MTTR (h)] )

3. Best practices

  1. Validate work-order data quality first: empty times or pending technical closures distort MTTR.
  2. Use a failure Pareto to prioritize critical assets.
  3. Split compliance by type: preventive, predictive, corrective, restorative and improvement.

Conclusion

A good maintenance dashboard isn't the one with the most charts — it's the one that tells you where to act first. Want it in your plant? Book a consultation.

ShareLinkedInWhatsApp

Latest articles

Ready to make better decisions with your data?

Book a free 30-minute consultation and get an initial assessment of your situation.