How to Calculate count emp no of average score

[Fia_Fiia]

Hello,

Please Help me,

I want to know how many active employees get scores above 80? in my raw data in one month there are 2 score values, I'm confused about how to add avg in the formula, this formula is not working because all employee counts are supposed to be one employee only counts average

Count({<[EmpStatusByMonth] = {[Active]}, [Score MQ] = {'>=80'}>}DISTINCT [Emp No])

Thanks

[sunny_talwar · Accepted solution]

May be this

Count({<[EmpStatusByMonth] = {[Active]}, [Emp No] = {"=Avg([Score MQ]) >=80"}>} DISTINCT [Emp No])

[Fia_Fiia]

Thank you for the information, this formula works.😊