Calculating service % Availability based in incident total time excluding non operational hours

[Werick]

Hi Experts
I have been working on this issue to much and seem to have hit a total blank

I have a problem to calculate the % availability for a service based on the total downtime of all the minutes the service had incidents logged against it. The measure should accommodate for slicing the data based on Dates (FY hierarchy) or sites (not all sites have all services) or Priority etc.

I have calculated the total minutes each incident impacted the availability for every incident. (Calculated Colum)
Each site has different operational hours and the impacted minute calculation takes this into account (closed times do not count to the total).

I have a measure in the Pbix file included but this calculates incorrectly.

Perhaps someone can assist me.

https://drive.google.com/drive/folders/1MFnRLiB81PmtC5t2muGxRVx0g_QPrelO?usp=sharing

Regards

[v-zhangti]

Hi, @Werick 

Maybe you can try the following methods.

Measure:

%Availability = 
VAR _BASELINE_VALUE =
    CALCULATE (SUM ( Incidents[Total Business Minutes for the Day] ),
        FILTER (ALL ( Incidents ),
            [priority] = MAX ( Incidents[priority] )
            && [supporting_service] = MAX ( Incidents[supporting_service] )))
VAR _VALUE_TO_COMPARE =
    CALCULATE (SUM ( Incidents[Business Minutes impacted] ),
        FILTER (ALL ( Incidents ),
            [priority] = MAX ( Incidents[priority] )
            && [supporting_service] = MAX ( Incidents[supporting_service] )))
VAR _Avail = DIVIDE ( _BASELINE_VALUE - _VALUE_TO_COMPARE, _BASELINE_VALUE )
RETURN
    IF ( ISBLANK ( _Avail ), 1, _Avail )

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Werick]

Hi

This does not solve the issue. 

The measure now only supports "slicing" the data for priority and not anything else.

I want to be able to change the priority columns to lets say Site or maybe FY-Month.

So i need a "generic" availability.