Need assistance to get this measure

Questions & Answers
1

If Type (in Questionnaire for SAP Application) =

{‘Upgrade’,‘Rollout’,‘Enhancement’,‘Geo-Expansion’,‘New Application’}

OR
(Type (in Questionnaire for SAP Application) = blank AND Solution Type (in Project level) =

{‘Enhancement’, ‘System Implementation’,‘System Retirement’}

)
Then ‘PLC Relevant’ = ‘Yes’
Else ‘PLC Relevant’ = ‘No’

2

Hi, @Bhargaviapple

Welcom to the eazyBI community!

It seems to me that you need to define a new calculated measure. Please find the information here: Calculated measures and members

To set conditions, please use CASE. Read more here: CASE statement

I’m assuming you have Issues selected in the rows and all the fields imported as dimensions. I need more information to help you better.

The pseudo-code should look something like this:

--calculated measure "PLC Relevant"

CASE WHEN 
[Questionnaire for SAP Application].CurrentMember.Name MATCHES
'Upgrade|Rollout|Enhancement|Geo-Expansion|New Application'
OR
(
[Questionnaire for SAP Application].CurrentMember.Name = '(none)' 
AND
[Solution Type].CurrentHierarchyMember.Name MATCHES
'Enhancement|System Implementation|System Retirement'
)
THEN 'Yes'
ELSE 'No'
END

Kindly,
Ilze

1 Like
3

Hi Ilze

Thank you so much, Its working now

Thank you,
Bhargavi

4

Hi Ilze,

I have one more requirement,
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

thanks
Bhargavi