Forum Discussion
Solved
Running Total Help
How can I determine the first intance the running total is less than or equal to 0? In this case I want the result to be 6. As its the first week that is non-zero. Thank you!
Hi,
This measure works
Measure = COUNTROWS(FILTER(VALUES('Resource Priority'[RT Good Week]),[10K 2PLD RT]>0))+1Hope this helps.
Hi,
Why should the answer be 6?
That is the first instance when the RT is <0. In your original post, you mentioned that you wanted to know the first instance when the RT is >0.
You are correct, I mispoke. I'll fix it in the original request.
