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])

     

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

That does not work for my scenario as I might have another value in the table that does not have 0 and I want to display.
Example:

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

solvisig

Then create a measure. Something simple like:

CALCULATE(AVERAGE(Table[Value]), Table[Value] <>0)