If statement within measure

[ianmk]

I am trying to make the "Max RVP" column in the pivot table have a red background color if the value is greater than 9.

 The expression for the "Max RVP" column:

=rangeMax([103: RVP After (Upper)],[104: RVP After (Middle)],[105: RVP After (Lower)],[2412: RVP - 1],[2413: RVP - 2],[3029: RVP - 3],[3033: RVP - 4],[3038: RVP - 5],[3043: RVP - 6],[3048: RVP - 7],[3053: RVP - 8],[3149: RVP - 9],[3153: RVP - 10],[3158: RVP - 11],[2: RVP - After])

The background color expression I currently have:

=if(rangeMax([103: RVP After (Upper)],[104: RVP After (Middle)],[105: RVP After (Lower)],[2412: RVP - 1],[2413: RVP - 2],[3029: RVP - 3],[3033: RVP - 4],[3038: RVP - 5],[3043: RVP - 6],[3048: RVP - 7],[3053: RVP - 8],[3149: RVP - 9],[3153: RVP - 10],[3158: RVP - 11],[2: RVP - After] > 9, red [,blue]))

This expression is yielding no results and there is no background color is white. 

How can I implement an If statement into the background color expression that includes the rangemax measure ("Max RVP")?

  

[joaopaulo_delco · Accepted solution]

Hi @ianmk !

     Try the following formula:

if(rangeMax([103: RVP After (Upper)],[104: RVP After (Middle)],[105: RVP After (Lower)],[2412: RVP - 1],[2413: RVP - 2],[3029: RVP - 3],[3033: RVP - 4],[3038: RVP - 5],[3043: RVP - 6],[3048: RVP - 7],[3053: RVP - 8],[3149: RVP - 9],[3153: RVP - 10],[3158: RVP - 11],[2: RVP - After]
)> 9, red() ,blue())