Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running Total suddenly reduced / stutters

Dear community

 

I have made a running total for the number of new patients in my organization. The formula is composed of three parts; the number of patients at the end of 2020 (611), running total for new patients up until last month, and running total based on a forecast model for future months. 

 

LøbendeAntal = 611 
+ CALCULATE(
	COUNTROWS('Forløb (udtræk)'), 
        'Forløb (udtræk)'[Kategori] = "Henvisning", 
        FILTER(ALLSELECTED('Forløb (udtræk)'), 'Forløb (udtræk)'[Dato] <= MAX('Forløb (udtræk)'[Dato])))
+ CALCULATE(
	COUNTROWS('Forecast'), 
        'Forecast'[Kategori] = "Henvisning", 
        FILTER(ALLSELECTED(Forecast), Forecast[Dato] <= MAX(Forecast[Dato])))

 

 

 

However, it seems something is wrong as a 'stutter' in the running total appears. This happens 3 times in the curve.

 

 

I have figured out it is a part of the second part of the equation, but cannot figure out how to fix it. There are no "reducements" in the data. It should only go up, up, up.

 

Any idea what could cause this?

 

Thanks in advance!

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    It's werid.Your report works fine on my side 😅. And I did not do any chanages except for changing the slicer's selected range:

     

    My Power BI Desktop version is 2.93.981.0 64-bit (May 2021) , please upgrade yours and try again.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    I have built a data sample to test your measure, but everything works fine.

    Measure = 
   CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Date]<=MAX('Table'[Date]))) 
+  CALCULATE(COUNTROWS('Forecast'),FILTER(ALLSELECTED('Forecast'),'Forecast'[Date]<=MAX('Forecast'[Date])))

    So please first check on which days the data is wrong or just share me with your pbix file after removing sensitive data so that I could have a test again.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Dear Eyelin

      Thank you so much for looking into it. As a new member of the community I don't have the option to attach files, but you should be able to access it through this link: https://we.tl/t-Lb7qLCw1CX

      The first decline happens at between May-Nov '27, and then again in '29 and '31. If I remember coorectly.

      /Heidi

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

         

        It's werid.Your report works fine on my side 😅. And I did not do any chanages except for changing the slicer's selected range:

         

        My Power BI Desktop version is 2.93.981.0 64-bit (May 2021) , please upgrade yours and try again.

         

        Best Regards,
        Eyelyn Qin
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.