Forum Discussion

kumsha1's avatar
kumsha1
Post Patron
5 years ago
Solved

Running Sum based on rank

Hi,   Can someone help me with calc. for RunningSum (Duration) based on the Rank. Below is the table data. TIA, cheers.   Rank and Duration are calc. measures.    
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this measure

    =SUMX(TOPN([Rank],CALCULATETABLE(VALUES(Data[Name]),ALL(Data[Name])),[Rank],1),[Duration (mins) - ALL])

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi kumsha1 ,

     

    Please try the measure like following screenshot.

     

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Try this measure

=SUMX(TOPN([Rank],CALCULATETABLE(VALUES(Data[Name]),ALL(Data[Name])),[Duration (mins) - ALL],1),[Duration (mins) - ALL])

  • kumsha1's avatar
    kumsha1
    Post Patron
    5 years ago

    Hi Ashish_Mathur , measure almost worked, thanks !

     

    how do i get the values in correct direction. Sorting on Rank didn't help.

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Hi,

      Try this revised measure

      =SUMX(TOPN([Rank],CALCULATETABLE(VALUES(Data[Name]),ALL(Data[Name])),[Duration (mins) - ALL]),[Duration (mins) - ALL])

      If it does not work, then share the link from where i can download your PBI file.

      • kumsha1's avatar
        kumsha1
        Post Patron
        5 years ago

        Ashish_Mathur , i have below values now.

         

        Sorry mate, .pbix can't be shared due to security reasons, it has all other Org stuff.