Forum Discussion
AverageX not consider 0 values
I need than this measure ignores zeros in the calculation: Promedio elasticidad Pbi MEJORADO = AVERAGEX(Filter( VALUES(Combinar1[Numero semana]) , [Filter Elasticidades Grandes] = "Si considerar" ...
i was able to exlude values of "elasticidad" when elasticidad is bigger than 100 in absolute value (creating a slicer to slice my "Elasticidad" measure using variables. but now i dont know how to deal with zeros in the calculation of my average.
bigger than 10**