Calculating energy use, getting different results.

[Anonymous]

Hi,

I'm trying to calculate the total, idle and active energy use from power measurements. I'm trying to do this by taking the average power over a given timespan, and multiplying this by the amount of hours that this timespan is over. However, the sum of the idle and active energy use is different from the total energy use. 

The scripts I use are: 

RunTime =

CALCULATE(

    COUNTROWS(DateTimes),

        FILTER(DateTimes,DateTimes[Status1]=1)

)/3600

ActiveEnergyUse = AVERAGEX(FILTER(Sensor1,DateTimes[Status1]=1),Sensor1[P(W)])*Sensor1[RunTime]/1000

IdleEnergyUse = AVERAGEX(FILTER(Sensor1,Sensor1[Status]=0),[P(W)])*(168-Sensor1[RunTime])/1000

TotalEnergyUse = AVERAGE(Sensor1[P(W)])*24*7/1000

The result is:

what is the cause of the Active and Idle energy uses not adding up to the total energy use? 

[Anonymous]

The difficulty here is that the power data is sent randomly, not in a fixed interval. This makes it relatively hard to extrapolate the energy use data from the power data. 

[tamerj1]

Hi @Anonymous 
Please try

TotalEnergyUse =
AVERAGEX ( Sensor1, [P(W)] * Sensor1[RunTime] ) / 1000

[Anonymous]

Hi Tamer,

this sadly does not work, it gives a result of 0 (when I remove the /1000, it gives a result of 0,59). I think this command takes the average of the power data *43 hours for each row, which is not the right result.