Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Resolver I
4 years ago
Solved

Trying to write a Measure that projects future

I am trying to write a measure that uses other measures to create a projection line for a line chart.  I want to add a green dotted line that starts with the Previous_Sprint and adds the Use Vel for ...
  • Alicia_Anderson's avatar
    4 years ago

    I was able to figure out a way to do both by myself.   May not be efficient, but it works.   

     

    1) First I had to create a numeric field instead of using text field.   (Sprint#, Current_Sprint#)

    2) Create a measure to capture points Done up to previous sprint.

    Effort-Done_Prev =
    CALCULATE([Effort-Done],
        FILTER(ALL('PI_Work'[Sprint#]), ('PI_Work'[Sprint#] < [Current_Sprint#])))
    3) Create a measure to determine future projected points.
    TVel =
    CALCULATE(sum(PI_Orig[UVel]),
         FILTER('PI_Work','PI_Work'[Sprint]>=[Current_Sprint]))
    4) Combine 2&3 together.
    Effort-Proj =
    [Effort-Done_Prev] + [TVel]
    5) Then I created a running total for above.
    Effort-ProjRT =
    CALCULATE([Effort-Proj],
        FILTER(ALLSELECTED('PI_Ref'[Sprint]),
            ISONORAFTER('PI_Ref'[Sprint], min('PI_Ref'[Sprint]), DESC))) 
    6) I created another measure that includes points only up to the Current Sprint.  
    Effort-Done_Curr =
    CALCULATE([Effort-Done],
        FILTER(ALL('PI_Work'[Sprint#]), ('PI_Work'[Sprint#] <= [Current_Sprint#])))
    7) Then I created a running total for above.
    Effort-Done_CurrRT =
    if([Effort-Done_Curr]<>Blank(),
    CALCULATE([Effort-Done_Curr],
        FILTER(ALLSELECTED('PI_Ref'[Sprint]),
            ISONORAFTER('PI_Ref'[Sprint], min('PI_Ref'[Sprint]), DESC))))