Visual Calculation: Running Sum Help

Hi Rondel, just add a visual filter and under ForTrend in the pane, Advanced Filter, select Is Not Blank.

Hi,

Just in case you want a non visual calculation solution, try this measure

Measure = if([story points]=blank(),blank(),calculate([story points],datesytd(calendar[date])))

Hi Rondel 

Please try the below calculation as measure in the chart.

RunningTotal_StoryPoints =
IF (
ISBLANK([Story Points]),
BLANK(),
CALCULATE (
SUM('Table'[Story Points]),
FILTER (
ALL('Calendar'),
'Calendar'[Date] <= MAX('Calendar'[Date]) &&
NOT(ISBLANK('Table'[Story Points]))
)
)
)


🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!