Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Uptime

hi, looking for some help

 

trying to work out a uptime availability for a cloud service, i have working in excel but wish to move it over to powerbi to do all the calculations

 


for the month, if there are no incidents then the availability should be 100%

each month has a difference amount of minutes due to difference in days which i have a table

 

 

if there is an issue calculate per month
- the number of total minutes for that month-the total downtime minutes for that month

- then divide the above figure by the

total minutes for that month

 

Service Availability =
DIVIDE(SUM('Service Reliability (days in month)'[HoursinMonth])-SUM('Issue'[Downtime]),(SUM('Service Reliability (days in month)'[HoursinMonth])))

 

this will give me a % availability but if there are is no downtime for that month, then the below matrix gives me blanks rather than  100%. i would like to show 100% in the empty slots below

 

 

ive tried a few different isempty, isblank, using VAR, using + 0 at end of measure

all with no luck

 

im sure im doing somehting wrong. just dont know what

 

thanks

 

Need Help

15 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Try this

    =IF(ISBLANK(SUM('Issue'[Downtime])),1,DIVIDE(SUM('Service Reliability (days in month)'[HoursinMonth])-SUM('Issue'[Downtime]),(SUM('Service Reliability (days in month)'[HoursinMonth]))))

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Ashish_Mathur 

      thanks for the help. i still get the same output.

      i forgot to add the "Group" column in my example above which defines the service/product

       

      would it be caused that i dont have a sum of that product group for that month? as shown in the sum of each month by "Group" matrix table. essentially the missing gaps means there were no downtime minutes for that month

      should i be changing how i sum up this first?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

        I am not sure of how much i can help but share the link from where i can download your PBI file.  In that file, please clearly show the result you are expecting to see.