2 Replies Latest reply on Jun 17, 2015 1:44 PM by emilie reimer

    Color by 'Select a Measure' Measure and Parameter

    emilie reimer

      Hello! Tough question here...

       

      I have a measure that looks like this:

      clip.png

      And a parameter that looks like this:

      clip2.png

       

      On the worksheet the user can toggle the measure to display:

      clip3.png

      Right now the color is driven by the 'Select-a-Measure' measure, but I need for it to compare itself to its 'last year' version.  I can create a calculated field for each of the six measures like this:

       

      If [Revenue] >= [Revenue LY] Then 1 Else -1 End

       

      But how will I implement this to drive the color card? Another calculated field?  What would the syntax look like?

       

      Thanks for any help!