Trying to calculate runtime percentage of machine.

[kgilmore33]

I'm collecting data from a machine every 5 minutes and have a column called 'runstatus' and we are writing a 1 or a 0 to that column.  We also have a time stamp along with other data for each record.  

Is there a simple way to calculate runtime % from just those two pieces of data (runstatus 1 or 0 and a timestamp?

I have a date slicer on the report.

Thanks.

[Anonymous · Accepted solution]

@kgilmore33 - Try a Measure like this:

Run % = 
DIVIDE(
    CALCULATE(COUNTROWS('Your Table'), 'Your Table'[runstatus] = 1),
    COUNTROWS('Your Table')
)

Hope this helps,

Nathan