Create a calculated member for Issue Type Dimension depending on Original Estimated Hours


There is typical use case for us Where we need to add a new calculated member to find the number of issues under certain issue type with Original Estimated Hours.

we tried adding a calculated member “Work Items with Original Estimates” under issue types using this formula:

([Issue Type].[Work Item Dev],
[Measures].[Issues with Original estimated hours])

But this is returning the same items as Just “Work Item”.

Can anyone help me on this please.

Hi, @GaneshKumaVary

Welcome to the eazyBI community.

The formula is correct and should give you the wanted result.

Please check if you have work items that have no Original estimated hours.
If the problem persists, please get in touch with us: Please send the print screen and report definition as well.


1 Like