Forum Discussion

solvisig's avatar
solvisig
Icon for Advocate III rankAdvocate III
7 years ago
Solved

Average aggregates discard 0 values

Hi,  I´m having issue with the aggregated value of average. the average value is calculated with all the underlying rows taken into account. I want it to discard 0 values.   underlying tabl...
Need Help
Tips and Tricks
  • Omega's avatar
    Omega
    7 years ago

    solvisig 

     

    Try creating the below measure: 

     

    Average = AVERAGEX(FILTER(Table1,Table1[Value] <>0),Table1[Value])

     

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
7 years ago

solvisig 

 

Try creating the below measure: 

 

Average = AVERAGEX(FILTER(Table1,Table1[Value] <>0),Table1[Value])

 

solvisig's avatar
solvisig
Icon for Advocate III rankAdvocate III
7 years ago

Omega, Thanks, This is exactly what I was looking for :)

 

I already created this DAX... but I had a feeling that there was some function for this:

MyAvg = CALCULATE(SUM(Table1[Value])/COUNTROWS(Table1);FILTER(Table1;Table1[Value] <> 0))