Forum Discussion
Solved
Average Score Excluding Zero
Yet another request (Sorry PBI Forum!)
See table below. I'm trying to find out the average quality score that excludes zeros (because they bring down the average).
Any help? Ignore the # of Members column. 🙂
Hi,
Assuming Quality score is a measure, try this measure
=if(hasonevalue(data[provider name]),[quality score],calculate([quality score],filter(values(data[provider name]),[quality score]>0)))
Hope this helps.
That worked! Thanks!
3 Replies
Hi,
Assuming Quality score is a measure, try this measure
=if(hasonevalue(data[provider name]),[quality score],calculate([quality score],filter(values(data[provider name]),[quality score]>0)))
Hope this helps.
That worked! Thanks!
You are welcome.