Status update from sub task to parent status

Questions & Answers
1

could you please help me on that

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 give a solution for this

Tried with below measure but Project Status not reflecting correctly

CASE WHEN
[Measures].[Warranty subtask status] MATCHES ‘Done|Approved|Handover Complete’

THEN ‘Project Status’ = ‘Completed’

END

image
image1326×1348 173 KB

thanks
Bhargavi

2

Hi @Bhargaviapple,

You don’t need to assign a value to the property within the calculated measure formula. The calculation for “Project Status” could look similar to the one below:

CASE WHEN
[Measures].[Warranty subtask status] MATCHES 'Done|Approved|Handover Complete'
THEN "Completed"
END

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com