Average Score Excluding Zero

[novotnajk]

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.  🙂

[Ashish_Mathur · Accepted solution]

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.

[Ashish_Mathur · Accepted solution]

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.

[novotnajk · Accepted solution]

That worked!  Thanks!

[Ashish_Mathur]

You are welcome.