Count rows based on text

[UK_User123456]

Hi All,

I have tried to use the following meausre to output the number of times the word "Faulty" appears in a column within my table but have probly used the wrong type of measure to do this, if anyone can help or point me in the right direction?

Total Faulty =

calculate (

COUNT('FaultyTbl'[Faulty/Non Faulty] ),

'FaultyTbl'[Faulty]="Faulty"

)

My table looks like the following:

Product ID	Faulty/Non Faulty
1	Faulty
2	Non-Faulty
3	Non-Faulty
4	Faulty
5	Faulty
6	Faulty
7	Faulty
8	Non-Faulty
9	Faulty
10	Faulty

TIA

[Tahreem24 · Accepted solution]

HI @UK_User123456,

I tried to  replicate your query so got expected result. Please see the below screen shot attached.

As per my observation there is some changes required in your formula.  The green font changes should be done at your end. As you are using some different column for filtering. As per your data there are only 2 columns Product ID and Faulty/Non-Faulty.

Total Faulty =

calculate (

COUNT('FaultyTbl'[Faulty/Non Faulty] ),

'FaultyTbl'[Faulty/Non Faulty]="Faulty"

)

 Please give Kudos to this effort and mark it as a solution if it helps you!