12 Replies Latest reply on Jan 10, 2018 6:21 AM by Roopa Shelton

    Help: Cannot Sum a Calculated Measure

    Roopa Shelton

      Kind of hard to explain this situation. I've attached my workbook.

       

      I've created multiple calculated measures from this data set. I've then created a measure called "Pre-Assigned Complexity Points" and another called "EFFICIENCY (Percent Closed by Complexity)" that reference other calcs in their own calcs. I'm able to see the correct result associated with each ID, but cannot sum the total for those 2 measure. In the end, I don't want to show all the detail. Only the SUMs, as is laid out on Sheet 11.

       

      Any help would be much appreciated!

      Thanks!!