Forum Discussion
Green_Cloud
3 years agoHelper I
Calculating Average while ignoring zero/null values
Hi All, I need to find out average based on the following dataset. But I just need to show the available month's value in the average when one of the month's value is null or zero. The formual I ...
- 3 years ago
Hi,
Thank you for your feedback.
Could you please check the below measure and the attached file, whether it suits your requirement?
Average (February & March) = ( ( CALCULATE ( SUM ( [Working Hour] ), FILTER ( 'Sample', 'Sample'[Month] = "February" ) ) ) + ( CALCULATE ( SUM ( [Working Hour] ), FILTER ( 'Sample', 'Sample'[Month] = "March" ) ) ) ) / COUNTROWS ( FILTER ( 'Sample', 'Sample'[Month] IN { "February", "March" } && 'Sample'[Working Hour] <> 0 ) )
Jihwan_Kim
3 years agoSuper User
Hi,
Please check the attached file whether it suits your requirement.
Thanks.
Green_Cloud
3 years agoHelper I
It should ignore the 0% conversion rate for John and Alex. It is considering that.