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].[预估任务工时]

Page tree

004-任务工时偏差