Forum Discussion

EJS1984's avatar
EJS1984
Regular Visitor
2 years 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 va...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years 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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years 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