Forum Discussion
Alicia_Anderson
Resolver I
4 years agoTrying 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 ...
- 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))))
Alicia_Anderson
Resolver I
4 years agoI 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))))