...
| Code Block | ||||
|---|---|---|---|---|
| ||||
[Measures].[实际任务工时]/ [Measures].[预估任务工时] |
按实际上线日期做测量
| Code Block |
|---|
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 |