Count row with Or Condition and able to show 0

[njxfoster]

Hi everyone! 

I want to create a measure that counts how many "Yes and "S" from this table, which should be 4, However, I also want the measure to able to show number "0" when there are no counts (instead if showing blank). 

How should I write this measure? 

Thanks in advance.

[serpiva64]

Hi,

you can try

Measure = CALCULATE(COUNT('Table'[Column1]), FILTER('Table','Table'[Column1]="S"||'Table'[Column1]="Yes"))+0