Cumulative sum for a line chart

Question

I have read through several threads for the same question and tried every variation without success. Can someone please tell me if I am doing something wrong?

The Cumulative line should be 55, 85, 112, etc.

rahulyadav · Answer

Hi&nbsp;Anonymous,The DAX formula that you are using is correct. I have replicated your source data and got the results you are expecting. if not confidential, is it possible to share the Pbix file or data that your are using?&nbsp;&nbsp;Thanks,Rahul

anonymous · Answer

I have the file but have limited all fo the data showing since it is confidential. How do I&nbsp;share it with you?&nbsp;

rahulyadav · Answer

Hi&nbsp;Anonymous,You can scramble the confidential data and upload the file to&nbsp;https://www.dropbox.com.&nbsp;Thanks,Rahul

anonymous · Answer

Hi,&nbsp;I have similar issue. Did you guys find solution ?

cmcmahan · Answer

It looks like the original issue is that&nbsp;Anonymous&nbsp;is filtering where Vendor Name &lt;= current Vendor Name when calculating cumulative total.However, the graph shows the data in order by Count of Item Number.&nbsp; The graph is sorted one way, the cumulative value is sorted another.&nbsp; It works in&nbsp;RahulYadav's solution because his Vendor Names are in alphabetical order AND in order by the count.To fix this, use the RANKX function to define a sort order, or (as a bad but quick option) filter where COUNT([Vendor Name]) &lt;= COUNT(SELECTEDVALUE([Vendor Name])) instead of on Vendor Name.

Forum Discussion

Cumulative sum for a line chart

5 Replies

Related content

Cumulative line chart

Line chart

Cumulative sum for a line chart

Line Charts with Cumulative values

Creating Cumulative Line Chart