Forum Discussion
Azure DevOps - Chart Recreation
Hi FEninja_ ,
The logic of Measure2 is as follows:
First get the start and end dates selected by your slicer via the MIN and MAX functions, then[Created Date]<=MIN('Calendar'[Date])&&[Completed Date]>=MAX('Calendar'[Date])&&[Work Item Type]=" User Story"filters the data within the time period selected by the slicer and finally obtains the result by calculation.
Since I'm not quite sure what your sprint start and sprint end refer to, you may need to make some adjustments based on the actual situation.
I hope this can help you.Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Your previous measure 2 was similar to what I need, however it removes filters for the individual teams, however I imagine that it can be customized using AllExcept? Do you think you can show me a version of your Measure 2 that uses all except (to exclude removing filters for different teams)?
I do apologize for the ambiguity, My understanding of the problem also lacks. The only thing that I clearly understand, is what I am trying to do. So I wanted to try to clarify my intent once more
| I am attempting to recreate this graph in Power-BI. However, I cannot figure out the DAX to make it work |
| Instead, my graph is flat. It seems that each date range is not dynamically changing - but is instead repeating the same values.
|
Here is a sample DAX measure that I created to test:
hello.UserStories =
// Stories - New, Closed, Removed
VAR sprintStart = [Current Sprint - Start Date]
VAR sprintEnd = [Current Sprint - End Date]
RETURN
CALCULATE(
[Total User Stories]+0
// calculate user stories from current date to earliest date (sprint start)
// Count from sprint start until date'date' - no further. (Date >= sprint start && date <= date'date')
,FILTER(
ALLEXCEPT(IDF,IDF[Iteration Path])
,IDF[Activated Date] >= sprintStart
)
)
So this is what I am trying to accomplish