Creating multiple cumulative line graphs in Power BI with DAX

0
votes

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!

1
powerbidax

1 Answers

1
votes

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!!