Forum Discussion
yakovlol
Resolver I
Resolver ICalculate Average without Zero values based on measure
Hello Team, Could you please help me with creating a measure? I need to Calculate the Average for (No group) ignoring zeros. The values for the second column are based on another measure [Count Mon...
Hi yakovlol ,
I suggest you to create a new [Average CountMonths] table based on original one.
New Average CountMonths = AVERAGEX(FILTER(VALUES(Table1[id]),[Average CountMonths]<>0),[Average CountMonths])+0Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yakovlolResolver I
Resolver IHello mlsx4
Many thanks for your help, but when I'm using this measure I have 1.00 everywhere, actually don't know why.
But for id 5 and 7 I need to have 3.00 like in picture above
Average CountMonths =
AVERAGEX('Table1',CALCULATE([Count Months],FILTER('Table1',[Count Months]<>0)))
Hi yakovlol ,
I suggest you to create a new [Average CountMonths] table based on original one.
New Average CountMonths =
AVERAGEX(FILTER(VALUES(Table1[id]),[Average CountMonths]<>0),[Average CountMonths])+0
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.