Drop prometheus series with certain values

Hi I am looking for a way to drop certain series when their value is equal to a specified number.

windows_service_state collects service states that are equal to 0 as a series even though this is not the current value.

If the service state is running, I want to collect one series for running (state = 1) and drop all the series the are equal to 0 (continue pending, pause pending, paused, stop pending, etc) aka that is not the current state.

I do not want to drop all series with state being paused because if the current state is paused (paused = 1), then I don’t want that dropped. I only want series dropped if their value is 0 and keep all series that equal 1 no matter what the state or service name is.

Example:
rule {
source_labels = [“name”, “value”]
separator = “;”
regex = “windows_service_state;0”
action = “drop”
}

I have tried to read through all the documentation and ask grot and the conclusion I am coming to is that it is not possible through alloy.

I am trying to figure out how to limit series that I send to grafana cloud to save money so please let me know if there is any way to limit series by value rather than entire metrics by name?