Calculate in determinated period time

[Anonymous]

Hello everybody,

I need help with a measure to calculate the number of custumers re-energized in the first 3 minutes from the start of the incident.

Basicaly i have a INCIDENT_ID, DATE/TIME and EVENT (filters columns) and Customers column (to sum).

For exemple:

In this case, the measure most to sum all custumers de-energized (red side "DES")  subtracting the re-energizeds (green side "ENER") both in first 3 minutes from the start of the incident. 

6750 - 2043 - 859 = 3848

Exemple

Database

Thank you all

[v-danhe-msft]

Hi @Anonymous,

How could you want to show your desired result and how could you make sure the first 3 minutes from the start of the incident?

For example, if your data like below, you could try to use this formula:

Measure = CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Legend]="DES"&&MINUTE('Table1'[Data])<=3))-
            CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Legend]="ENER"&&MINUTE('Table1'[Data])<=3))

Result:

If I misunderstand you, please offer me more information if possible.

Regards,

Daniel He

[Eric33]

@v-danhe-msft 

 I have to create this other account because i cant log in the other with organizational problem.
 
Thank you.
 
Actually, i need that the measure calculate "Sum(Des) - Sum(ener)" in a period of 3 minutes starting from the beginning of each incident.
 
In my exemple i filtered just 1 incident, so, in this case the measure have to calculate considering a period from first date/time (10/11/2018 15:01:55)  +3 minutes  (10/11/2018 15:04:55), ignoring everything that is not in this period. And reply this rule for any incident
 
For exemple:
 
10/11/2018 15:01:55 (first date/time)
10/11/2018 15:03:38 (consider)
10/11/2018 15:03:54 (consider)
10/11/2018 15:12:12 (NOT consider because > first date/time +3 minutes)
 
Then, in the considered period the measure have to calculate the Sum(Des) - Sum(Ener).
 
To make sure that the measure i'll consider this period for each incident, i think the measure have to filter each incident and consider the min(date/time)+3 to calculate the sums and subtract.
 
Thank you again.