实际任务工时
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