how to check if value of original estimate is zero before doing calculated measure

[Sakina]

so i am creating a calculated measure that will return variance between actual Log hours vs Orignal estimates, but in case if  my actual is zero it returns infinity , so before doing my calculation i want to check that only if the value of my measure field is non zero then do calculation

[Roberts Čāčus · Accepted solution]

Hi @Sakina ,

I recommend implementing a condition with the CASE statement before the calculation and checking whether the actual logged hours are greater than zero. Some of the predefined calculated measures have such a condition. Please view the formula of the measure "Average resolution days" as an example.

CASE WHEN [Measures].[Issues resolved] > 0 THEN
[Measures].[Total resolution days] / [Measures].[Issues resolved]
END

See the eazyBI documentation page on defining calculated measures here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures.

Best,

Roberts // support@eazybi.com

[Sakina]

@Roberts Čāčus  that's what i did 😀

[Alex Koxaras _Relational_]

Hi @Sakina ,

Perhaps you mean Nonzero()?

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/nonzero

[Sakina]

hi @Alex Koxaras _Relational_ 

thank but, i got the other way around