I hope you are trying this in a dashboard. Try to place the records with 0 in a separate sheet . In the dashboard disable the hyperlink and enable it only for the >0 records.
Thanks for the response Pavan.
However these zero's ('0) are not constant/static values.They keep changing. The ask is in the entire grid wherever there is a zero the user should not be able to click on it.however if there is a measure value > 0 the click on it should take the user to the next view.