Trying to calculate in DAX the Perfect system availability in Seconds and Percentage

[Dallas7890]

Hello 

I am new to DAX, and I'm trying to figure out the monthly percentage for our 8 systems if they were to run perfectly in the month. In Excel it's the number of days in the month since we installed the system to the current date. 
157 = Sum of the Days column

13564800 = seconds/day/network feed

108518400 = This is the Perfect Seconds for the total of 8 Network feeds

or
108518400 

I have a table in my PBI report called WebOps Discrepancies

Any help would be greatly appreciated.

[Anonymous · Accepted solution]

Hi @Dallas7890 ,

In the Power BI, you can try to use:

column_day_each month
                     =eomonth(table[date],0)

sec/day/network feed measure=var _1=max(table[sec/day/network feed])
return
if(isinacope(table[date}),_1,sumx(all(table),table[sec/day/network feed]))

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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