Incorrectly counts when filtering

[dwenlvov]

Hi!I have table:

DATE	ID	RATING
2020-12-01	10	1
2020-12-03	13	2
2020-12-03	10	3
2020-12-05	11	2
2020-12-01	15	3
2020-12-03	13	5
2020-12-03	15	5
2020-12-05	10	4

and i want add table like this:

DATE	COUNT_RATING100
2020-10	645
2020-11	725
2020-12	57

COUNT_RATING100 = SUM (Aggr (IF (Count([RATING])>='100',1,0 [ID])

If I filter by date(month), I have like this:

DATE	COUNT_RATING100
2020-11	5648

and that true

I dont know why COUNT_RATING100 is considered incorrect in first example

help