Forum Discussion

Kareus's avatar
Kareus
Helper I
2 years ago
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!  
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This measure works

    Measure = COUNTROWS(FILTER(VALUES('Resource Priority'[RT Good Week]),[10K 2PLD RT]>0))+1

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

This measure works

Measure = COUNTROWS(FILTER(VALUES('Resource Priority'[RT Good Week]),[10K 2PLD RT]>0))+1

Hope this helps.