Power Bi Dax formula to sequentially number each occurrence of working/failure for the day

[RajKarun]

Hi All

I need a formula to sequencially number Working and down for a site and Machine Id for the day.

The first time it goes down in the day is 1 and the second time it goes down is 2. I could easily write a formula for each instance but I need them grouped and numbered,  so that I can measure the time it was continously working or down.

The first time it is working its 1 (same for down), the next time it is 2.

I need all the consecutive ones to be the same number so that I can create a summarize table to get the start and end time of the event (Working & Down) and time.

I was able to create a rankcc column but everytime it is working (site statsu = 1) it is duplicating as 1 but not incrementing it.

Any help is much appreciated.

Thanks Raj

[RajKarun]

Hi All,
I have reposted/updated as I believe I might have confused you with the code etc.
I have attached the data below. I need the yellow column "count"

The table is sorted by site, Machine Id & Date/Time,

I want to create a table that displays the following result.
The main filters are the date, Machine ID & Site.

I have used the count column to identify the occurances.

[RajKarun]

Hi thanks for your reply. I was trying to use index but didnot help.

this was the actual code

[some_bih]

Hi @RajKarun I just notice: in VAR part there is index column reference but not in RANKX formula definition?