How to count rows with specific value in Power Query

Thanks Edhans.

I am creating this Row count column #"Added Custom 8" only after the custom column #"Added Custom 7" I created previously:

And I am creating the custom column from Add Column ribbon -> Custom Column and below is the code I have:

And when I click OK and run, getting the below error:

Text.Contains is wrong. It should be Text.Contains([Test], "No") 
You have one argument with an equal sign. Get rid of that and replace with a comma, for 2 arguments.