Forum Discussion
Running Total suddenly reduced / stutters
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.
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.
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.
/HeidiHi 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.Wait, what! I'm relieved, but also a bit annoyed haha - I've spent soooo many hours trying to figure it out. I'm gonna have to check which version I have, and I'll post an update and mark the post solved afterwards. Thank you!