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
- Validate work-order data quality first: empty times or pending technical closures distort MTTR.
- Use a failure Pareto to prioritize critical assets.
- 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.