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
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
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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
131 | |
81 | |
65 | |
61 | |
55 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |