Now your solution is working for cluster name filter, but if i select values from any other filter. percentage is incorrect.
FYI: cluster name filter is not applicable on machine count but applicable on percent. please find the screenshot below.
Numerator calc should be same as we do not want Not clustered in calculation.
Numerator calculation :
countd(if [cluster name] <> "Not Clustered"
so, in below screenshot %age should be (test cluster 2 + test cluster 1) / machine count (as we are not including "not clustered" in numerator)
(2+4/10)*100 = 60% but its showing 28.57
Thanks for your Quick Reply. but i don't want to apply filter cluster name on machine count. as of now machine count is changing by applying cluster name filter.