Forum Discussion

aslee's avatar
aslee
Helper I
9 years ago
Solved

Burndown with visual level filter

Hi All,   I am trying to create a burndown of remaining tasks left, based on the task end date, which falls into an Agile sprint number. Each task is also assigned to a team. Sample data below:   ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi aslee

     

    This small tweak might help.  And if you want a bar chart for each sprint, you could have a separate table for that.  Let me know if it looks close.

     

    burndown = 
	CALCULATE(
		COUNT(tasks[Key]), 
		FILTER(
			ALLEXCEPT('Tasks','Tasks'[Team]), 
			tasks[sprint]>=MIN(tasks[sprint])
			)
		)
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi aslee

 

This small tweak might help.  And if you want a bar chart for each sprint, you could have a separate table for that.  Let me know if it looks close.

 

burndown = 
	CALCULATE(
		COUNT(tasks[Key]), 
		FILTER(
			ALLEXCEPT('Tasks','Tasks'[Team]), 
			tasks[sprint]>=MIN(tasks[sprint])
			)
		)
aslee's avatar
aslee
Helper I
9 years ago

Thanks Phil_Seamark - that definitely looks better! 

 

Could you clarify what you mean by a separate table? 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi aslee,

     

    Just thinking the chart you get with my measure doesn't match perfectly your desired chart.  I can have a look at this a little later tonight to flesh out a measure that means the chart looks closer to your desired result.

    • aslee's avatar
      aslee
      Helper I
      9 years ago

      Relatively new to DAX but managed to come up with this solution for anyone else who might need it:

       

      Created a new table 'Join' where I manually entered our sprint numbers into one column.

      Then created a calculated column 

      Burndown = COUNTX(
                 FILTER(tasks, 
                 tasks[sprint]>='Join'[sprint]), tasks[key])

       

      This essentially fills in the gaps for sprints where no tasks are due. 

       

      I also created 4 additional columns with filters for each team, which makes it easy to use in the column charts. 

       

      Eg

       

      Team 1 = COUNTX(
                 FILTER(tasks, 
                 tasks[sprint]>='Join'[sprint]&&tasks[team]="1"), tasks[key])

       

      Thanks Phil_Seamark for your push in the right direction!