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