Sum not working

[Anonymous]

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

Story Points Done Late = IF('Sprint Burndown'[Closed Date].[Date] < 'Sprint Burndown'[Sprint End Date].[Date]  , 'Sprint Burndown'[Story Points],0)

[Anonymous]

@Greg_Deckler 

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)

[v-yinliw-msft]

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.

[Anonymous]

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

[Greg_Deckler]

@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/n4TYhF2ARe8

If 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.