Calculated measure in graph does not respond to drilldown

[Joost]

Hi,

I have made calculated measures to show the cumulative values of two columns (Actuals and Target). The formula works the same for both except they use a different column from the Entries table (Actual and Target respectively). So the cumulative actual formula looks as follows 

Cumulative Actual = CALCULATE(
    SUM (Entries[Actual]); 
    FILTER(ALL(Entries);
        Entries[WeekNum]<=MAX(Entries[WeekNum])
        )
)

And this shows me the correct total of the cumulatives when comparing this total value of the graph with the gauge meter on this page of the report (182.37m).

However, when using the slicer on the left (or selecting items in the matrix tables for that matter), the graph does not display the correct value anymore. This can be concluded by comparing the gauge meter actual value (1m) to the graph actual value (143.38m).



The visuals have interaction on as can be seen in the screenshots and the gauge meter + table values are correct this way. I feel as I am overlooking a simple thing but can't figure this out. How can I get my graph (with the calculated cumulative measure) to respond to this drilldown as expected? 

EDIT: forgot screenshots

[Phil_Seamark · Accepted solution]

HI @Joost

What happens when you try this small tweak?

Cumulative Actual = CALCULATE(
    SUM (Entries[Actual]); 
    FILTER(ALLSELECTED(Entries);
        Entries[WeekNum]<=MAX(Entries[WeekNum])
        )
)

[Joost]

Thank you Phil! That did the trick. Learning something new everyday.