Forum Discussion

AndreSatziack's avatar
AndreSatziack
Icon for Helper I rankHelper I
9 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 - CALCULATE(SUM(Relatorio_Completo_2017[Hours]), FILTER(ALLSELECTED(Relatorio_Completo_2017[Criado]),ISONORAFTER(Relatorio_Completo_2017[Criado],MAX(Relatorio_Completo_2017[Criado]),DESC))) 

 

Need Help

18 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 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
      Icon for Helper I rankHelper I
      9 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
        Icon for Helper I rankHelper I
        9 years ago

        Hello Anonymous,

         

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

         

        Thank you very much :)

         

        Best Regards.