I have the following table :
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 :
Thank you in advance for your help
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.
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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.