1 Reply Latest reply: Apr 19, 2016 1:03 AM by Chris Snyders RSS

    Color Expression for 2 Measures in Bar Chart

    Danielle Estrella

      Hi,

       

      I am creating a bar chart that compares 4 categories' current and previous scores. I would like the current score for each category to be a different color and all previous scores to be grey. However, I am having trouble using an IF statement since the score calculations require a set analysis. The formulas for current and previous scores are the following:

       

      Current Score

      (sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Earned])

      /sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Possible]))

       

      Previous Score

      (sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Earned])

      /sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Possible]))

       

       

      Thanks,

      DJE