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.

     

Kareus's avatar
Kareus
Helper I
2 years ago

You are correct, I mispoke.  I'll fix it in the original request.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Share the download link of the PBI file with the RT measure already written.

  • Kareus's avatar
    Kareus
    Helper I
    2 years ago
    Here is my RT measure ...

    10    K 2PLD RT = SWITCH(TRUE(),
    CALCULATE(SUM('Resource Priority'[10K 2PLD])-('Manual Inputs'[VALUE Weekly 10k]*([MEASURE RT Good Week Count])),
        FILTER(ALLSELECTED('Resource Priority'[RT Good Week]), ISONORAFTER('Resource Priority'[RT Good Week], MAX('Resource Priority'[RT Good Week]), DESC))) >= -[VALUE Weekly 10k],

        [Week Position %]*'Manual Inputs'[VALUE Weekly 10k]+
        CALCULATE(SUM('Resource Priority'[10K 2PLD])-('Manual Inputs'[VALUE Weekly 10k]*([MEASURE RT Good Week Count])),
        FILTER(ALLSELECTED('Resource Priority'[RT Good Week]), ISONORAFTER('Resource Priority'[RT Good Week], MAX('Resource Priority'[RT Good Week]), DESC))),

        CALCULATE(SUM('Resource Priority'[10K 2PLD])-('Manual Inputs'[VALUE Weekly 10k]*([MEASURE RT Good Week Count]))
    ))
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      I'll need the file.

      • Kareus's avatar
        Kareus
        Helper I
        2 years ago

        Sorry, stupid question.  How do I share it?