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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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