Hi @Phil_H13 ,
The behavior looks weird. However, please note that the function Approximate Count Distinct isn't 100% accurate. The function uses the HyperLogLog (HLL) method of approximating distinct counts. It is configured to guarantee the value is within 5% of the actual value 95% of the time.
Though, you may want to raise a ticket with us and we will happy to take a look.
Thanks!