I would like to have a count of the number of issues (stories, tasks) that did not have Original Estimated entered. I understand eazyBI may not keep track of the history of this field and probably should use Remaining Estimated measures such as “Remaining estimated hours”, “Remaining estimated hours change”, or “Remaining estimated hours history”.
However, I am not able to get the count of the number of issues. For example
NonZero(Count( Filter( PreviousPeriods([Time].CurrentHierarchyMember), ([Measures].[Remaining estimated hours history] = 0 OR IsEmpty([Measures].[Remaining estimated hours history]) ) ) ))
I tried using one condition or multiple ones, various combination of the Remaining estimated hours measures. None of the formula gives me the correct count so far (I checked against the actual count by hand in JIRA).
Please kindly help give me some guidance what I have done wrong.
thanks in advance.