Measure for status from subtask to parent

I want to create as measure with this below condition.
If the status of sub-task is either ‘Done’, ‘Approved’, or ‘Handover Complete’, then the corresponding project status associated with that sub-task is assumed to have occurred.

Please suggest me.

Hi, @Bhargaviapple

Welcom to the eazyBI community.

From the description, it’s not clear what you want to do with the status, but, the part I get results in such pseudo script:

CASE WHEN 
[Status].[Done] > 0 
OR
[Status].[Approved] > 0
OR
[Status].[Handover Complete] > 0
THEN
"project status occurred"
END

Kindly,
Ilze

Hi Ilze,

Could you please help on this.
We created one defined measure as PLCRelevant with below measure.

CASE WHEN
[Measures].[Issue SLMTD Type] MATCHES
‘Upgrade|Roll-out|Enhancement|Geo-Expansion|New Application’
OR
(

[Measures].[Issue SLMTD Type] = ‘(none)’
AND

[Measures].[Issue Solution Type] MATCHES
‘Enhancement|System Implementation|System Retirement’
)
THEN ‘Yes’
ELSE ‘No’
END

We need this PLC Relevant in Pages. How can we get this filed in Pages.

Hi Ilze,

Please help on measure to get the transition status based on the parent and subtask status.
If the issue passes through the pre-mobilization then the transition status pre-mobilization only need to come YES. Other status need to come blank.

In this below report few subtasks status are TODO then the transition status should come blank. If it is approved, Done, Handover then only it should be YES.

Thanks in advance,
Bhargavi


Hi ilze,

Please reply