Count Specific Data in column

[MohamedSalem999]

Hello,
I try make Expressions to help to count some specific data in column, I just want to count 1,2,3 to give total count of them.

[AleksiAlkio]

Try to use.. COUNT(SELECT(Table[KeyColumn],[TRC]<4))

[MohamedSalem999]

He give me that error

[MohamedSalem999]

To be more clear i have this two table first table[Collection] is the source of data 

second table for user when he chose input, he should him total of count of 1,2,3

[AleksiAlkio]

Do you need to count numbers 1, 2 and 3 from the whole table or only from that specific equipment?

[MohamedSalem999]

specific equipment

[AleksiAlkio]

It sounds the [TRC] is a text column, and that's why the error. You can either change the column type to a number or use COUNT(SELECT(Table[KeyColumn],NUMBER([TRC])<4))

[MohamedSalem999]

i try it but he gives me not correct answer.

[AleksiAlkio · Accepted solution]

Then it needs something like..

COUNT(SELECT(Table[KeyColumn],AND([Equipment]=[_THISROW].[Equipment],NUMBER([TRC])<4)))

[MohamedSalem999]

thank you so much for help it work

[AleksiAlkio]

You're welcome!