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 ,

 

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!

 

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

Hi NikhilChenna 
This too is not working. The table visual keeps loading. Can you please help me out. 18k rows is a small dataset. Dont know why it keeps loading. Please help me out. Struck with this for last 1 week

 

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

    Hi sharong , Is it possible can you share you pbix file. 

     

     

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

        Hi sharong ,

         

        Is this the output you want ?

         

         

        Regards,

        Nikhil Chenna

         

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