How do I remove "zero" or null responses from my graph?

[datadelta]

I have a data set that has a number of zeros and/or nulls as responses to questions.  When charting out the averages, I'm trying to eliminate the zeros from that average.  Despite having put the filter set to "greater than 0" they are still counted towards the average.

I've provided an image to show the April average is clearly not being calculated correctly due to it still counting zeros.

Thanks!

[Ritaf1983 · Accepted solution]

Hi @datadelta 
Try to use this Dax formula for your measure

Avg percentage= CALCULATE( AVERAGE(TableName[your column]), FILTER(TableName, TableName[your column] <> 0 ))
Link to sample file 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.