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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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