Count(If()) based on max date gives wrong totals

[Kwame]

Greetings, community,

I'm curious about the reason behind the inaccurate sums shown by this particular formula.

=Count(DISTINCT If(Aggr(NODISTINCT Max(Date), Date) = Date, ID))

Upon exporting to Excel, the tally doesn't match the expected total of 58,306.

I would greatly appreciate your assistance. Thank you very much.

[Or]

Why would the expected total be 58306? You are counting distinct values, which presumably can repeat over multiple months (but are not counted twice for the total)?