Creating multiple cumulative line graphs in Power BI with DAX

Question

I'm trying to figure out how to create a cumulative line graph in Power BI. The problem I'm having is I have a lot of variables that need to fit in and I'm having some trouble to make it work. I've got the following columns in a table. Product certification Delivery date Product volume

The product volume column has an associated data and certification number to each volume row. I want to create a graph that has cumulative lines for each product certification.

To create the cumulative graph by volume I've written a DAX formula that goes like this:

Cumulative volume =
CALCULATE (
    SUM ( CONCRETE[Product Volume] ),
    FILTER (
        ALL ( CONCRETE ),
        CONCRETE[Delivery Date] <= MAX ( CONCRETE[Delivery Date] )
    )
)

However, this doesn't account for the Product certification. It only sums up the total volume to date. Anyone have any thoughts on how to correct this?

Thanks so much for any help!

Mboolean · Accepted Answer · 2020-01-15 15:45:54Z

1

Just use Date column while filtering for ALL,

Cumulative volume =
CALCULATE (
    SUM ( CONCRETE[Product Volume] ),
    FILTER (
        ALL ( CONCRETE[Delivery Date] ), 
        CONCRETE[Delivery Date] <= MAX ( CONCRETE[Delivery Date] )
    )
)

I hope it helps!!

answered Jan 15, 2020 at 15:45

Mboolean

3923 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

carlstrom96 Over a year ago

Hi! Thanks for the response! However, I'm still missing how I might be able to filter by Product Certification, so that each individual line in the graph represents the cumulative volume for that particular certification. Does that make sense? Thanks for the support!

Mboolean Over a year ago

I think you just need to add your new measure to chart and use product certification as legend then it will breakdown volume measure by product certification.

carlstrom96 Over a year ago

Yeah that's what I was thinking too but for some reason that jacks up my calculations and starts summing things way beyond what the actual numbers are. Not sure why. Do you have suggestions for a good resource to turn to for more in-depth Power BI information?

Mboolean Over a year ago

Check this out... daxpatterns.com/cumulative-total

carlstrom96 Over a year ago

Much appreciated!

Collectives™ on Stack Overflow

Creating multiple cumulative line graphs in Power BI with DAX

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related