Find count of closed cases

[Anonymous]

HI, I'm stuck so pls help. I have table with cases changing statuses, what I want to know is how many cases went to CLOSED status after other statuses. Here is Sample file .

I'd like to have a measure which would show me how many cases got to status CLOSED and they were prevoius in specific status.

[TeigeGao]

Hi @Anonymous ,

Could you please tell us which cases can be seen as a "went to CLOSED status after other statuses" one? After analysizing your sample data, I haven't found a case with closed status.

Best Regards,

Teige