How do I create this measure to filter out scores of 0?

[JordanJackson]

Hi there, 

I started out with the following measure 

Average Score New (%) =  AVERAGE( 'Scores'[Score]) / 5 ) * 100

This gave an average score in the percentage format which is the desired way for this measure. However i noticed that it was taking 0's into account. And so I tried to adapt the measure as seen below in the picture to filter out scores of 0. 

If anyone knows the correct dax in order to show this average as a percentage whilst filtering out 0's please do let me know.

Thanks

[PabloDeheza · Accepted solution]

Hi there!

I think your measure should look more like this:

Average Score New (%) =

CALCULATE(

AVERAGE( 'Scores'[Score] ) / 5,

'Scores'[Score] <> 0

) * 100

Let me know if that works!

Cheers!

[JordanJackson]

This works for me, thankyou so much!

[ryan_mayu]

@JordanJackson 

pls try 

=CALCULATE(AVERAGE('Scores'[Score]), FILTER('Scores','Scores'[Score]<>0)) /5 * 100

[JordanJackson]

This also works! Thankyou for your help!