Help creating a line value for Clustered Column Chart?

[powerbinoobster]

So I have this Clustered Column Chart.

I want to create a meansure/line value that starts at 949 and continues adding the "Originated" value for each month so like this.

So 949 + 49 = 998 for Jan, 998 + 73 = 1071, etc.. How would I create this measure?

[v-yanjiang-msft · Accepted solution]

Hi @powerbinoobster ,

According to your description, here's my solution.

Sample:

Create a measure.

Originatd measure =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Month Number] <= MAX ( 'Table'[Month Number] )
    ),
    'Table'[Originated]
) + 949

Get the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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