Forum Discussion

cdawidow's avatar
cdawidow
Helper III
6 years ago

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

 

3 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    6 years ago

    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?

    • cdawidow's avatar
      cdawidow
      Helper III
      6 years ago

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

      • AntrikshSharma's avatar
        AntrikshSharma
        Community Champion
        6 years ago
        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.