Have you tried encapsulating it in a SUM?
SUM(IF(Date >= DATE(2024, 6, 25) AND Date <= DATE(2024, 7, 24), Active users, 0))
Maybe then you can mix the active users (metric) that meet the criteria you placed on date (dimension).