Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.