Forum Discussion
Kareus
Helper I
Helper IRunning 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.
Ashish_Mathur
Super User
Super UserHi,
Why should the answer be 6?
KareusHelper I
Helper I
- Ashish_Mathur
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.
- Kareus
You are correct, I mispoke. I'll fix it in the original request.
- Ashish_Mathur
Share the download link of the PBI file with the RT measure already written.