Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
cdawidow
Helper III
Helper III

Cumulative sum error

Hi guys, running into an error when calculating a cumualtive sum in a calculated column.  My formula is listed below but my totals are not adding up any idea why?
 
Column 9 = CALCULATE(
[Actual Customer Margin],
FILTER(
ALL('Customer Info'),
'Customer Info'[tgm] <= EARLIER('Customer Info'[tgm])))
 
gh.PNG

 

3 REPLIES 3
AntrikshSharma
Super User
Super User

@cdawidow  What is the definition of [Actual Customer Margin] and can you share the diagram view of the model or if possible the pbix file?

Unfortunately I cannot share the file, actual customer margin is Gross Margin - Costs To Serve  which I have in the form of a measure

Cool, then I may not be able to help as I see context transition is happening here and I need to see the model to understand how the filters are flowing.

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.