Azure DevOps - Chart Recreation

[FEninja_]

UPDATE: PBI FILE => https://www.dropbox.com/s/250cnke1ulpy4sy/sample-problem.pbix?dl=0

===

Hello All,
Relative Newbie here.

I am attempting to recrease an Azure DevOps Chart in PBI - but I am encountering issues.
The numerical count doesn't add up. Azure shows 5 stories , but my count only shows 2

Can someone provide insight into what I may be doing wrong?

[v-jianboli-msft]

Hi @FEninja_ ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, 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.

[v-jianboli-msft]

Hi @FEninja_ ,

Can you describe specifically how the date selected by the slicer should filter the User Story? What is the logic of its calculation? There are many columns in the file you provided, and I'm not quite sure which ones should be used to calculate.

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.

[FEninja_]

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"))

Also, If you could explain the logic in your FILTER statement - that would be helpful also

[FEninja_]

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)?

[v-jianboli-msft · Accepted solution]

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.

[FEninja_]

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

[v-jianboli-msft]

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.

[FEninja_]

Hello Jianbo,

Thank you very much for taking the time to help.

I have attached the PBI File, Here

Please let me know if you have any trouble accessing it