004-任务工时偏差

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Hours spent]>0
  ),
  ([Measures].[Hours spent],
    [Time].CurrentHierarchy.DefaultMember)
)

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Hours spent]>0
  ),
  ([Measures].[Original estimated hours],
    [Time].CurrentHierarchy.DefaultMember)
)

[Measures].[实际任务工时]/ [Measures].[预估任务工时]

CASE WHEN
  [Measures].[Issues with 实际上线日期]>0
THEN
Sum(
  Filter(
    DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
--condition to filter out the relevant issues
    [Measures].[Issues with 实际上线日期]>0
  ),
--numeric value to sum
 ([Measures].[Hours spent],
--the next row resets the Time dimension
  [Time].CurrentHierarchy.DefaultMember)
)
END