@Racheal Welcome to Microsoft Q & A Community Forum. Kindly note that the query of a metric measurement alert rule must include an AggregatedValue column of a numeric type.
Log alerts that do not meet this condition are failing to be disabled with powershell cmdlet Update-AzScheduledQueryRule. Product Group team has a note of this to provide the error message better.