Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper 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 ...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity 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
Icon for Helper III rankHelper 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
    Icon for Community Champion rankCommunity 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.