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,

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Create a measure like this and add to the table, it will show one rows.

 

 

calculate(max(table[story point]),
filter(summarize(table,table[issue_key],"_maxdt",max(table[date]),"_maxGp",max(table[issue_key])),
			table[issue_key]=[_maxGp] && max(table[date]=_maxdt)))

 

You can use sum, if needed.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin