Compare Text in a Count Expression

[yastaaa]

Hi,

I am doing this count:

COUNT(SELECT(Races[Sel_1],[Sel_1]=[win])) this give one result

If i do: COUNT(SELECT(Races[Sel_1],[win]=[Sel_1])) and this gives another result

None of the results are correct.

[win] and [Sel_1] are text columns that are referenced to another a table. The text colum is 2 character only for Horse Number. ie: 1,1A, 2,3,4 etc.

I dont know what is happening because in Google Sheets the same comparison is working.

---

COUNT(
…The list of values of column ‘Sel_1’
…from rows of table ‘Races’
…where this condition is true: ((The value of column ‘Sel_1’) is equal to (The value of column ‘win’)))