topic Re: Cumulative sum error in DAX Commands and Tips

Cumulative sum error

cdawidow — Fri, 28 Aug 2020 12:06:38 GMT

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

Re: Cumulative sum error

AntrikshSharma — Fri, 28 Aug 2020 12:14:36 GMT

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?

Re: Cumulative sum error

cdawidow — Fri, 28 Aug 2020 12:16:19 GMT

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

Re: Cumulative sum error

AntrikshSharma — Fri, 28 Aug 2020 12:21:44 GMT

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.