Forum Discussion

tlwest86's avatar
tlwest86
Helper I
4 years ago

Line Chart with Cumulative Total Issue

I am wanting to create a line chart that shows our cumulative total of incoming and outgoing products by week for this fiscal year.  I tried the following DAX but could not get desired results.  The DAX does not return an error but the line graph does not update.  Can someone please look at my file below?

 

Cumulative Total Completed Column =
CALCULATE (
SUM('Pending & Completed ALL ADS'[Completed Claims Column]),
FILTER (ALLSELECTED('Pending & Completed ALL ADS'), 'Pending & Completed ALL ADS'[Comp Date] <= MAX ('Pending & Completed ALL ADS'[Comp Date])))

 

Cumulative Line Chart 

 

I greatly apprecaite your help in advance!!!! 🙂

Need Help

2 Replies

  • tlwest86's avatar
    tlwest86
    Helper I
    4 years ago

    Anyone that can assit with making this a cumulative line chart?

     

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      4 years ago

      Hi  tlwest86 

      Does this chart only show the count per week?  I have sent an access request, please check.

       

       

      Best Regards,

      Community Support Team _Tang

      If this post helps, please consider Accept it as the solution to help the other members find it more quickly.