topic Re: Burndown chart in DAX Commands and Tips

Burndown chart

EJS1984 — Sun, 08 Sep 2024 11:08:37 GMT

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

Re: Burndown chart

Greg_Deckler — Sun, 08 Sep 2024 12:44:52 GMT

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