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.

[tamerj1 · Accepted solution]

Hi @njxfoster 

please try

=

IF (

NOT ISEMPTY ( 'Table' ),
COUNTROWS (

FILTER ( 

'Table',

'Table'[Completion_Status__c] IN { "Yes", "S" }
)

) + 0

)