Power BI - Essential IT & Technology DAX Measures

on

 Essential IT & Technology DAX Measures

1. System Uptime & Downtime

Total Downtime Hours = SUM(SystemLogs[DowntimeHours])

Downtime MTD = 
CALCULATE([Total Downtime Hours], DATESMTD(DateTable[Date]))

Downtime YTD = 
TOTALYTD([Total Downtime Hours], DateTable[Date])

Downtime LY = 
CALCULATE([Total Downtime Hours], 
SAMEPERIODLASTYEAR(DateTable[Date]))

Uptime % = 
DIVIDE( (SUM(SystemLogs[TotalHours]) - [Total Downtime Hours]),
 SUM(SystemLogs[TotalHours]), 0 )

 Tracks system availability and SLA compliance.

2. Incident Management

Total Incidents = COUNTROWS(Incidents)

Incidents MTD = 
CALCULATE([Total Incidents], DATESMTD(DateTable[Date]))

Incidents YTD = 
TOTALYTD([Total Incidents], DateTable[Date])

Incidents LY = 
CALCULATE([Total Incidents], SAMEPERIODLASTYEAR(DateTable[Date]))

Critical Incidents % = 
DIVIDE(
    COUNTROWS(FILTER(Incidents, Incidents[Severity] = "Critical")),
    [Total Incidents],
    0
)

 Monitors incident volume and severity trends.

3. Service Desk Performance

Total Tickets = COUNTROWS(ServiceDesk)

Tickets MTD = 
CALCULATE([Total Tickets], DATESMTD(DateTable[Date]))

Tickets YTD = 
TOTALYTD([Total Tickets], DateTable[Date])

Avg Resolution Time = AVERAGE(ServiceDesk[ResolutionTime])

Resolution Time YTD = 
TOTALYTD([Avg Resolution Time], DateTable[Date])

 Tracks support workload and resolution efficiency.

4. Patch & Compliance Tracking

Patched Systems = COUNTROWS(FILTER(Systems, Systems[PatchStatus] = "Updated"))
Total Systems = COUNTROWS(Systems)

Patch Compliance % = 
DIVIDE([Patched Systems], [Total Systems], 0)

Patch Compliance YTD = 
TOTALYTD([Patch Compliance %], DateTable[Date])

 Ensures systems are updated and compliant.

5. Resource Utilization

Resource Utilization % = 
DIVIDE(SUM(Resources[HoursUsed]), SUM(Resources[HoursAvailable]), 0)

Resource Utilization YTD = 
TOTALYTD([Resource Utilization %], DateTable[Date])

 Measures workforce or infrastructure usage efficiency.

6. Project Delivery

Projects Completed = COUNTROWS(FILTER(Projects, Projects[Status] = "Completed"))

Projects Completed YTD = 
TOTALYTD([Projects Completed], DateTable[Date])

On-Time Delivery % = 
DIVIDE(
    COUNTROWS(FILTER(Projects, Projects[DeliveryStatus] = "On-Time")),
    [Projects Completed],
    0
)

 Tracks project completion and timeliness.

 Takeaway

These measures give IT & Technology teams time-based insights into uptime, incidents, service desk performance, compliance, resource utilization, and project delivery. By layering date intelligence functions (DATESMTD, TOTALYTD, SAMEPERIODLASTYEAR), you can present monthly, yearly, and historical comparisons that help optimize IT operations and align with business goals.


Comments

Post a Comment