cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Cumulative total by index and product - so close!

Thanks to the help here I am pretty close to what i'm planning to achieve.

The following calculated column measure has helped me

Cumulative Actual Qty =
CALCULATE(
SUMX(Allocation,Allocation[Allocation Qty]),
FILTER(Allocation,Allocation[PDE] = EARLIER(Allocation[PDE]) && Allocation[Index]<= EARLIER(Allocation[Index])))

As pictured the total runs up to every PDE and then restarts again but I would like it to start again when the DC changes.

So the numbers restarts at the yellow highlight point, not sure if i need to changer

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

Actual cumulative quantity ?
CALCULATE(
SUMX(Assignment,Assignment[Assignment Quantity]),
FILTER(Allocation,Allocation[PDE] a EARLIER(Allocation[PDE]) && Allocation,Allocation[DC] ? EARLIER(Allocation[DC]) && Allocation[Index]<- EARLIER(Allocation[Index])))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

3 REPLIES 3
Highlighted
Super User IV

Actual cumulative quantity ?
CALCULATE(
SUMX(Assignment,Assignment[Assignment Quantity]),
FILTER(Allocation,Allocation[PDE] a EARLIER(Allocation[PDE]) && Allocation,Allocation[DC] ? EARLIER(Allocation[DC]) && Allocation[Index]<- EARLIER(Allocation[Index])))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Thanks!
First one works, i was doing something similar but couldn't quite see it.

Highlighted
Community Support

Hi , @rhys1987

Could you please tell me whether your problem has been solved?
More people will learn new things here. If you haven't, please feel free to ask.

Best Regards,
Community Support Team _ Eason

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors