How to calculate % availability

[walterdp]

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 based on the tickets with "Critical" priority

OPENED	CLOSED	TIME TO RESTORE
1/1/2023	1/3/2023	48
1/1/2023	1/5/2023	120

I have problems with denominator because it should change based on the time period selected 

For instance

TOTAL DOWNTIME	MONTH	TOTAL MONTH HOURS	UPTIME (1 - (DOWNTIME / PERIOD EVALUATED, in this case, JAN)
168	Jan	744	77%

Any ideas?

Thanks!

W.

[walterdp]

Hi Marcel:

Did you have the chance of reviewing the dummy file?

Thanks

[marcelsmaglhaes]

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]

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

[marcelsmaglhaes]

Hey @walterdp !

Sorry for delay. Have you solved it yet? If no, you can share the pbix?

Regards,
Marcel

[walterdp]

Hola, @marcelsmaglhaes !

Here's the dummy file

https://1drv.ms/u/s!AtL7NB5vXDVohfJUZgtgTza13Jk1Eg?e=IRUXns

Thanks!

W.