Dax to countrows in one column, but rows based on value on another column

[AMBP1973]

axHello Everyone,

I am looking to count rows of a column named 'Title', where the values are title of documents, but exclude those rows that has values of 'superseded' in the 'Document/process update' column in the same table? I would appreciate any assitance with a dax measure for this.  Thanks in advance

Example of table 

Title	Document Process Update
Manual - Root Cause analysis guide
Procedure - System Reviews	Superseded

[AMBP1973]

Perfect! Thankyou for your prompt response 🙂

[Idrissshatila · Accepted solution]

Hello @AMBP1973 ,

try this:

measure = Calculate( countrows(TableName),'TableName' [Document Process Update] <> "Superseded"))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡