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
thanks
Bhargavi