Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
krishna0's avatar
krishna0
Helper II
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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