Forum Discussion

FEninja_'s avatar
FEninja_
Helper I
3 years ago
Solved

Azure DevOps - Chart Recreation

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 enc...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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_'s avatar
FEninja_
Helper I
3 years ago
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