Count with 2 dependent conditions

[vnqt]

Hi

I have the following table : 

Name	Serial number	Status
name1	number1	Expired
name1	number2	Running
name3	number3	Running
name3	number4	Expired
name5	number5	Running
name6	number6	Preparation
name7	number7	Running
name8	number8	Preparation
name9	number9	Running
name10	number10	Preparation
name11	number11	Running
name12	number12	Expired

I would like to sort out the Serial number, if the Serial numbers have the same name, need to filter by Status "Running"

The result would remove the 2 lines below :

Name	Serial number	Status
name1	number1	Expired
name1	number2	Running
name3	number3	Running
name3	number4	Expired
name5	number5	Running
name6	number6	Preparation
name7	number7	Running
name8	number8	Preparation
name9	number9	Running
name10	number10	Preparation
name11	number11	Running
name12	number12	Expired

Thank you in advance for your help

[krishna0]

Hello!

Wouldn't it be enough to just remove "Expired" status? Or you need the additional check? This measure would look like:

CALCULATE ( DISTINCTCOUNT ( 'Table'[Serial number] ), 'Table'[Status] <> "Expired" )

 In case you do not need Distinctcount, you can just replace with a count. Please share some more details, because I might not understand your question fully.

BR

[vnqt]

This doesn't work in my case, I can't just remove Status Expired. Because I have many cases like name12, it doesn't have a duplcate.

 Result should be 10