Forum Discussion
Sum not working
I have been using this below to calc when an item is PAST the Sprint End Date compared to the Closed Date? this calc doesn't seem to work for some reason....it won't sum like all the other columns I've created. It's a whole number, summarize is chosen just like the others...I've tried not summarizing... I'm stumped
4 Replies
- Greg_DecklerCommunity Champion
Anonymous I can't be certain but maybe a measure totals problem?
First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8If not, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. - v-yinliw-msftCommunity Support
Hi Anonymous ,
Notice that your formula has a [Story Points], but I can't see this column or measure in the screenshot of the table.
Could you please tell me how to calculate this and whether the Story Points Done Late is a column?
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
v-yinliw-msft Greg_Deckler It is a calculated column for Story Points Done if that helps
Sprint Done Points = IF('Sprint Burndown'[Date].[Date] = 'Sprint Burndown'[Sprint End Date].[Date] && 'Sprint Burndown'[State] IN {"Done","UAT","Closed"} , 'Sprint Burndown'[Story Points],0)
- AnonymousNot applicable
Screenshots
Calc column
Story Points Done Late = IF('Sprint Burndown'[Closed Date].[Date] > 'Sprint Burndown'[Sprint End Date].[Date] && 'Sprint Burndown'[State Category] = "Completed", 'Sprint Burndown'[Story Points],0)