Forum Discussion
novotnajk
Resolver I
Resolver IAverage 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 Me...
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!
Ashish_Mathur
Super User
Super UserHi,
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.
novotnajkThat worked! Thanks!
- Ashish_Mathur
You are welcome.