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:

 

TeamSprintKey
1120ABC-1
2125ABC-2
3122ABC-3
4120ABC-4
2121ABC-5
3123ABC-6
4127ABC-7
1129ABC-8
2124ABC-9
3126ABC-10
2122ABC-11
1120ABC-12
4125ABC-13
4126ABC-14
4127ABC-15
2128ABC-16
1123ABC-17
3122ABC-18
2124ABC-19
1125ABC-20

 

This is the best I have come up with:

burndown = CALCULATE(COUNT(tasks[Key]), FILTER(ALL(tasks), tasks[sprint]>=MIN(tasks[sprint])))

 

Here I encounter two problems:

 

  1.  It does not take into account visual filters, so I can't easily filter by team, unless I include the specific team in the calculated measure. I would rather just have 1 measure rather than create 4. 
  2. There may be sprints where there are no tasks due in that particular iteration, so the column for that sprint shows as empty. I want it to still show a sum of remaining tasks left regardless.

Here is what happens when there is no filter of team - works fine

 

 

Here is what happens when I change the visual filter to team 1. Shows as 20 tasks for team 1, and missing columns of data

 

 

And here is what I would ideally like it to look like, as an example for Team 1

Any assistance would be appreciated!

  • 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])
    			)
    		)

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee

    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

      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

        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.