Forum Discussion

sharong's avatar
sharong
Icon for Helper I rankHelper I
3 years ago

Running Total for non date column

I am trying to do running total on non date column. I am trying to show it in a table visual. I have 18k rows. Following the below dax, its working for me if i limit rows to first 1000 rows. But for...
NikhilChenna's avatar
NikhilChenna
Icon for Skilled Sharer rankSkilled Sharer
3 years ago

Hi sharong ,

 

I think the issue is loading the measure. The measure seems bit complex. 

I suggest you to use SUMX and minimize the formula.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

  • sharong's avatar
    sharong
    Icon for Helper I rankHelper I
    3 years ago

    Hi,
    Can you provide me the minimized formula using sumx . will try it out

    • NikhilChenna's avatar
      NikhilChenna
      Icon for Skilled Sharer rankSkilled Sharer
      3 years ago

      Hi sharong ,

       

      Can you only share you sample table as well as a expected output table for it. so that it will be easy for me to test it out too.

       

      Regards,

      Nikhil Chenna

       

      Appreciate with a Kudos!! (Click the Thumbs Up Button)
      Did I answer your question? Mark my post as a solution!

      • sharong's avatar
        sharong
        Icon for Helper I rankHelper I
        3 years ago

        This is the existing table i have. I want a new column "Running sum" of receivables based on rank st. 
        Total number of rows in dataset is 18079 rows.