Create a Dynamic Reference Line Based on A Cumulative Measure

nxsjd

Hi,

Here is your PBIX file with the relevant corrections and additions to make the dynamic reference line. A couple of notes:
1. to calculate the cumulative values you need to wrap the 'Table" in ALL instead of ALLSELECTED.

2. I've created two examples:

       - one with a fixed reference line (April Example)

       - A dynamic Reference Line example

3. To be able to let the user select the reference month, you need to create a disconnected table to use as the slicer. You will see this in the relationships pane.

Hope this helps!

Regards,
Paul.

PS: Link to the file

nxsjd

Interesting, because that adds a new context, and that entails re-doing the measures. 

This seems to work:

For the cumulative 'real' and 'target' measures, you need to wrap the table ref. with the ALLSELECTED (as per your orignal measure).

Cumulative real = CALCULATE(SUM('Table'[Real]);
    FILTER(ALLSELECTED('Table');
        'Table'[Month Order]<= MAX('Table'[Month Order])
    )
)

Cumulative target = CALCULATE(SUM('Table'[Target]);
    FILTER(ALLSELECTED('Table');
        'Table'[Month Order]<= MAX('Table'[Month Order])
    )
)

And for the dynamic cumulative target line, you need:

Dynamic Target Ref Line = 
VAR Selectedmonth  = SELECTEDVALUE(Months[Month Order])

RETURN
CALCULATE([Cumulative Target]; 
    FILTER(ALLSELECTED('Table');
        'Table'[Month Order] <= Selectedmonth)
)

Here is the PBIX file

Try it and see if it works.

Regards,

Paul.