Select a row based on today's date then select then next oldest 2 time frames.

[Anonymous]

select the Sprint Name(s) based on Today <= Sprint Start Date and Today >= Sprint End Date (and not in the future) then add up the number of sprints selected (eg. 4 sprints selected) and divide the sum of the Sprint Points Done by that number. 381/4 in other words

[Anonymous]

Do I have a typo in here? "Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2."

Sprint Velocity = divide( calculate(SUM('Sprint Burndown'[Sprint Done Points]), filter('Sprint Burndown'[Iteration Start Date] <= Today() && 'Sprint Burndown'[Iteration End Date]>= Today)),

calculate(Distinctcount('Sprint Burndown'[Sprint Name]), filter('Sprint Burndown', [Sprint Start Date]<= Today() && [Sprint End Date]>= Today))

)

[PaulDBrown]

There's a ( missing in both the last Today expression

TODAY()

[Anonymous]

Not enough coffee :)... thanks!!

I made the adjusment

Sprint Velocity = divide

    (calculate

        (SUM('Sprint Burndown'[Sprint Done Points]),

            filter('Sprint Burndown', 'Sprint Burndown'[Iteration Start Date] <= Today() && 'Sprint Burndown'[Iteration End Date]>= Today())),

    calculate(Distinctcount('Sprint Burndown'[Sprint Name]), filter('Sprint Burndown', 'Sprint Burndown'[Iteration Start Date]<= Today() && 'Sprint Burndown'[Iteration End Date]>= Today())

))

and got a ridiculously high number or zero if I SUM it in the card... so I thought maybe the distinct count was throwing it off so I made a calc column to see

CountSprints = calculate(Distinctcount('Sprint Burndown'[Sprint Name]), filter('Sprint Burndown', 'Sprint Burndown'[Iteration Start Date]<= Today() && 'Sprint Burndown'[Iteration End Date]>= Today()))

shouldn't the count sprints column show a '1' ?

[amitchandak]

@Anonymous , Try measure like

divide( calculate(Sum(Table[Sprint data points]), filter(Table, [Sprint Start Date]<= Today() && [Sprint End Date]>= Today)),

calculate(Distinctcount(Table[Sprint Name]), filter(Table, [Sprint Start Date]<= Today() && [Sprint End Date]>= Today))

)