Counting the text values

Question

I have data like below

ProductID	OrderID	Flag	Value
111	1	Yes	10
111	2	No	10
112	1	No	20
112	2	Yes	20

I need to count only "Yes". 

I tried with count distinct but for order 112 it is counting only "No". 

I need to count "Yes" even if 1st row entry in data is "No"

Answer 1

Hi!

Create a column using contains( ) like below.

Count = IF(CONTAINS('table','table'[Flag],"Yes"),1,0)

Answer 2

To get the count of only yes, use this Dax.

Yes_count = IF('29Aug'[Flag]=="Yes",1,0)