Forum Discussion

EJS1984's avatar
EJS1984
Regular Visitor
1 year ago
Solved

Burndown chart

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's avatar
    Greg_Deckler
    1 year ago

    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

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    1 year ago

    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