Forum Discussion
Count with 2 dependent conditions
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 | number2 | Running |
| name3 | number3 | Running |
| 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
2 Replies
krishna0Helper II
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