Forum Discussion

Helper 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...

Skilled Sharer

3 years ago

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!

Helper I

3 years ago

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

NikhilChenna
Skilled 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
  Helper 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.
  - NikhilChenna
    Skilled Sharer
    3 years ago
    Hi sharong ,
    
    Create the below measure ,
    
    Running total sales =
    VAR IndexRank = [Rank ST]
    
    RETURN
        CALCULATE (
            SUM ( 'table1'[Receivables]),
            FILTER (
                ALL ( 'table1'[customer_no] ),
                IndexRank
                    >= RANKX ( ALLSELECTED ( 'table1'[customer_no] ), [sum],, ASC, DENSE )
            )
        )
    
    Regards,
    Nikhil Chenna
    
    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!