Forum Discussion

chipchidster's avatar
chipchidster
Resolver I
6 years ago
Solved

SUM Distinct for table with duplicate values

I am struggling with an issue that i am sure is easier to solve that I am making it! I'm trying to create a graph showing velocity for each of our software teams.  This is being driven from a summar...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi chipchidster ,

     

    We can try to use the following dax to meet your requirement:

     

    History_sprint_summary =
SUMMARIZE (
    history,
    history[issue_key],
    history[to_status],
    history[story_points],
    "to_date", MAX ( history[to_date] ),
    "max_sprint_date", MAX ( history[sprint_to_date] )
)

     


    If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     


    Best regards,

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi chipchidster ,

 

We can try to use the following dax to meet your requirement:

 

History_sprint_summary =
SUMMARIZE (
    history,
    history[issue_key],
    history[to_status],
    history[story_points],
    "to_date", MAX ( history[to_date] ),
    "max_sprint_date", MAX ( history[sprint_to_date] )
)

 


If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 


Best regards,

 


Best regards,

 

chipchidster's avatar
chipchidster
Resolver I
6 years ago

Thank you v-lid-msft and apologies for only coming back to this today - it's the first time i have had a chance to make further changes to my dashboard.  With a little tweak, this is now working perfectly.  I have actually changed the MAX to MIN so that it is picking up the first time each issue goes into that status, which for velocity purposes makes more sense.