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
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]
See the eazyBI documentation page on defining calculated measures here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures.
Roberts // firstname.lastname@example.org