Forum Discussion
Solved
How to average without zero and by different category
Hi all, I need help with this for a survey which I have conducted. I have this set of survey which I am trying to find the average hours/ people without zero: Place People Category Tas...
Hi, byWing
You can try the following methods.
Measure = Var _table=FILTER('Table',[Hours per month]<>0) Return AVERAGEX(_table,[Hours per month])Is this the result you expect? If not, please provide more sample output.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, byWing
You can try the following methods.
Measure =
Var _table=FILTER('Table',[Hours per month]<>0)
Return
AVERAGEX(_table,[Hours per month])
Is this the result you expect? If not, please provide more sample output.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly