COUNT + SELECT do not work

[deltai]

I need help.

I'm trying to count how many times a person got "YES".

However, the person's name repeats on different dates, depending on how the classroom is called.

There are 2 tables:

DB_PESSOAS and DB_CHAMADA

It is necessary to repeat the PERSON_NAME, as it links to another table that controls the CALL DATE.

I'm not getting the desired result.

See the formula:

COUNT(SELECT(DB_CHAMADA[NOME_PESSOA],
AND([NOME_PESSOA]=[_THISROW].[NOME_PESSOA],
[PRESENCA]='SIM'),
true)
)

[TeeSee1]

The last parameter of a SELECT statement set TRUE ELIMINATES any duplicates. If you want to retain duplicate results, you should set it to FALSE. 

[deltai]

Hello,

I try this form before post this question, dont work ( instruction TRUE or FALSE)

Unfortunity return NOTHING or ZERO or hight values.

Shoud return value =4

[ChristianLi]

First try checking if the SELECT statement returns a list. And check whats on that list.

If it is not what your expecting there's probably something wrong you sour SELECT condition.

[deltai · Accepted solution]

Friend´s

I solved this problem...see:

COUNT(FILTER("DB_CHAMADA",
               AND(([_THISROW] = [NOME_PESSOA]),
                        ([PRESENCA]="SIM"))))

I based on formula REF_ROWS.

tks everyone