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.
Hi FEninja_ ,
According to my test, the result of your sample is 7 instead of 2:
Am I misunderstanding something or is your example different from the sample provided?
If you want to get the user story generated during a certain date, you can try this Measure:
Measure 2 = CALCULATE(DISTINCTCOUNTNOBLANK(Data[Work Item ID]),FILTER(ALL(Data),[Created Date]<=MIN('Calendar'[Date])&&[Completed Date]>=MAX('Calendar'[Date])&&[Work Item Type]="User Story"))Final output:
If this measure could not help, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
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.
