Forum Discussion

walterdp's avatar
walterdp
Helper I
3 years ago

How to calculate % availability

Hi all:   I need to measure availability (uptime) of systems and countries. Results change based on filters (time span, system selected, etc). I have the numerator: the sum of hours of downtime bas...
Need Help
marcelsmaglhaes's avatar
marcelsmaglhaes
Super User
3 years ago

Hey walterdp !

If in your visual you have the month, maybe you can create a measure using ALLSELECTED function. 

MY_MEASURE =
CALCULATE (
1 - DIVIDE ( [TOTALDOWNTIME], [TOTALMONTH], 0 ),
ALLSELECTED ( 'TABLE'[MONTH] )
)

Let me know if it helps.

Regards,
Marcel

walterdp's avatar
walterdp
Helper I
3 years ago

Hi marcelsmaglhaes 

Thanks for replying. Not sure if I was clear enough when explaining the problem. 

What I need to do is to calculate availability with number of hours of downtime in a given period of time divided by total number of hours in the same given period of time. That period should be flexible (filtered by a visual object)

 

I've tried something similar to what you've mentioned, but I believe I'm not doing it well.

Here's the formula

 

Disponibilidad 3 = CALCULATE (1 - DIVIDE(SUM('Incs Cerrados'[Time to Restore]) --Sum of all downtime
,DATEDIFF(MIN('Calendario'[Date]),MAX('Calendario'[Date]),HOUR),1)) -- Calendario is a date table.

 

 

Here are the results

  • Creada (Start Date) is the field in "Inc Cerrados" table that's used as the filter to define the period of time mentioned before
  • Total Tiempo is the denominator of the division mentioned above (DATEDIFF(MIN('Calendario'[Date]),MAX('Calendario'[Date]),HOUR),1))) This field should change when modifying filters