Forum Discussion

AndreSatziack's avatar
AndreSatziack
Helper I
8 years ago
Solved

help with a simple burndown chart

Hello Team, I need to create a burndown line chart with sample data below. I tried use the follow dax code but don't worked for me, can you help me? Thank you very much.   BurnDown = 180 - CALCU...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    AndreSatziack,

    Create the following measures in your table and check if you get expected result.

    Burndown = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(), 3200 - CALCULATE(SUM(Relatorio_Anual_2017[Hours]),FILTER(ALL(Relatorio_Anual_2017),Relatorio_Anual_2017[Created]<=MAX(Relatorio_Anual_2017[Created]))))
    Burndown1 = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(),3200-CALCULATE([Total hours],DATESYTD('Calendar'[Date],"31/12")))



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

AndreSatziack,

Create your measure using DAX below.

BurnDown = 180-CALCULATE(SUM(Relatorio_Completo_2017[Hours]),FILTER(ALL(Relatorio_Completo_2017),Relatorio_Completo_2017[Criado]<=MAX(Relatorio_Completo_2017[Criado])))

If the above Dax doesn't help, please help to share sample data of your table and post expected result here.

Regards,
Lydia

  • AndreSatziack's avatar
    AndreSatziack
    Helper I
    8 years ago

    Hello Anonymous,

     

    Thank you very much for your help :)

     

    This DAX helps but I can't filter by customer organization, it only shows the total amount of all customers.

    Another questions is there a trend line to predict when the available hours will be depleted.

    See bellow and Download my files Files Sample

    Thank you very much

     

    • AndreSatziack's avatar
      AndreSatziack
      Helper I
      8 years ago

      Hello Anonymous,

       

      How are you? Did you get a look at my example?

       

      Thank you very much :)

       

      Best Regards.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        AndreSatziack,

         

        What is your expected result when you set the value to customer1 in visual level filters? And what type of trend line would you like to add?

        Regards,

        Lydia