Need DAX expression

[Anonymous]

Please Help me to create a Calculated column.

I need a DAX expression to create a calculated column.

I have two columns Status and fruit,

 I need a Calculated column for numbering differnt fruits on each status

Output Should looks like below

My aim is to create a Matrix as shown below

Thanks.

[amitchandak]

@Anonymous , Create a new column

Countx(filter(Table, [fruit] = earlier([fruit]) && [Status] = earlier([Status])),[Status])