Hi @Brahmareddy  
This didn't work
count(*) * 1.0 / count(distinct field1) AS cal1)

gave me same error. 


But as per this feature release 
https://docs.databricks.com/aws/en/dashboards/datasets/calculated-measures

this should work out of box, otherwise it's not much useful. 
Can we check if there is an issue with this feature. 

I can try to make it work by using derived columns through CTE. 
but just curious if the feature released supports it.