Multiple case when with only one iteration

Questions & Answers
1

Hi there,
This code should work, but it only iterates the first row of my data then suddenly goes awol

CASE WHEN
([Measures].[Issue Day 2 Scope Quality]=“Defined” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“Defined” AND [Measures].[Issue Assessment Timeline]=“Appropriate”
OR
[Measures].[Issue Day 2 Scope Quality]=“Unclear” AND [Measures].[Issue Assessment Timeline]=“Appropriate”)
THEN “GREEN”
ELSE
CASE WHEN
([Measures].[Issue Day 2 Scope Quality]=“Defined” AND [Measures].[Issue Assessment Timeline]=“Swag”
OR
[Measures].[Issue Day 2 Scope Quality]=“Unclear” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“Undefined” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“Undefined” AND [Measures].[Issue Assessment Timeline]=“Swag”)
THEN “RED”
ELSE
CASE WHEN
([Measures].[Issue Day 2 Scope Quality]=“UnClear” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“UnClear” AND [Measures].[Issue Assessment Timeline]=“Appropriate”)
THEN “YELLOW”
END
END
END

I use it in the new 6.2 cell formating to render a color depending on conditions
end result is…

image
image209×831 2.62 KB

2

Will answer myself this works better

CASE WHEN
([Measures].[Issue Day 2 Scope Quality]=“Defined” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“Defined” AND [Measures].[Issue Assessment Timeline]=“Appropriate”
OR
[Measures].[Issue Day 2 Scope Quality]=“Unclear” AND [Measures].[Issue Assessment Timeline]=“Appropriate”)
THEN “GREEN”
ELSE
CASE WHEN
([Measures].[Issue Day 2 Scope Quality]=“Defined” AND [Measures].[Issue Assessment Timeline]=“Swag”
OR
[Measures].[Issue Day 2 Scope Quality]=“Unclear” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“Undefined” AND [Measures].[Issue Assessment Timeline]=“Appropriate”
OR
[Measures].[Issue Day 2 Scope Quality]=“Undefined” AND [Measures].[Issue Assessment Timeline]=“Swag”)
THEN “RED”
ELSE
CASE WHEN
([Measures].[Issue Day 2 Scope Quality]=“UnClear” AND [Measures].[Issue Assessment Timeline]=“Expedited”
OR
[Measures].[Issue Day 2 Scope Quality]=“UnClear” AND [Measures].[Issue Assessment Timeline]=“Appropriate”)
THEN “YELLOW”
END
END
END
sorry for the formating… my lines are too long.