Burndown chart

[EJS1984]

I am trying to create burndown graphs for 'Task Closure' as well as 'Hours Spent', example file attached. The charts work until slicer filter is applied on 'project', at which point I believe date values are being inlcuded in the chart outside the filter. I have tried numerous differnt FILTERs but struggling to understand and resolve. Grateful for any advise.

Example.pbix 

[Greg_Deckler · Accepted solution]

@EJS1984 Here's one way to solve it:

HoursBurndown NC = 
    VAR __Projects = DISTINCT( 'Projects'[Project ID] )
    VAR __MaxDate = MAX( 'Hours'[Date] )
    VAR __Sum1 = SUMX( FILTER( ALL('Hours' ), [Project ID] IN __Projects ), [HoursUsed] )
    VAR __Sum2 = SUMX( FILTER( ALL( 'Hours' ), [Project ID] IN __Projects && [Date] <= __MaxDate ), [HoursUsed] )
    VAR __Result = __Sum1 - __Sum2
RETURN
    __Result