Highlight 3 continuous discarded tems

[Anonymous]

Hi All,

Can someone help me with DAX to highlight items which have 3 consecutive 'Discard' as per rank:

Item	Status		Rank
A	Discard		1
A	Select		2
A	Discard		3
A	Discard		4
A	Discard		5
B	Discard		1
B	Discard		2
B	Discard		3
C	Select		1
C	Not fit		2
C	Discard		3
C	Discard		4
C	Discard		5

In above case items 'A' and 'C' have 3 continuous 'Discard', I want a DAX which identifies them.

Thanks.