Count Events that are consecutively over a certain total time

[datastrategy]

I would like to know "how many visits to a location are over say 3 minutes" because that will say the person is definently there... I have a large table to sensors that tell where a person is, but need to count the total time for each location and then if( function and count function to see how many times a day a person is say "in the bathroom."

here's the PBIX file...

https://1drv.ms/u/s!Al_7ttRtqlRUg7h0hSQbBI1YSXZVCw?e=Gl5dYB

I can count if each sensor lasts longer than 3 minutes, but want to count if the consecutive events are larger than 3 or 5 minutes.

the hallway here would be the sum of the total duration for that time.  Maybe the date axis is then the min time for each segment of locations?

[datastrategy · Accepted solution]

so hallway below would be counted as 4 times this day in this picture.  (I'm binning by 15 min increments, so might have missed others that are within the 15 min segments, just using this for explanactino purposes)

[datastrategy · Accepted solution]

so hallway below would be counted as 4 times this day in this picture.  (I'm binning by 15 min increments, so might have missed others that are within the 15 min segments, just using this for explanactino purposes)

[v-chuncz-msft · Accepted solution]

@datastrategy 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/How-to-create-ID-variable-by-value-an-other-variable/m-p/36...