Forum Discussion
Running Total Not Calculating Correctly with Index
Hello,
Perhaps I've asked this question already but haven't worded correctly. My calculated measure is attempting a running total based off a rank value that resets to 1 every 8 hours.
I would like the expression to show the sum of the "Difference 2" column every shift, so it would ideally show a reset of 0-8 hours run every time the rank reset to 1. The problem I am having is that it isn't calculating correctly. The first 3 shifts are resetting, but once the rank and shift starts to duplicate (i.e.: 1 on the next shift), it includes the sum from the prior run into the sum of the new run, meaning the sum is now including every time Rank =1. The graph below illustrates what I mean. The ideal graph would just show 0-8 three time per day.
How should I fix my formula?
2 Replies
- JoeKulasaRegular Visitor
Forgot to include a picture of my data with the "Rank" column:
- AnonymousNot applicable
Hi JoeKulasa ,
Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.
You can save your files in some cloud sharing platforms and share the link here.
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Yuna