Forum Discussion

datadelta's avatar
datadelta
Icon for Helper III rankHelper III
3 years ago
Solved

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

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!

 

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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.

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    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.