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 , 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!

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

    Yeah but why every value in running sum column is same. I want a cumulative sum 

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

    Hi NikhilChenna 

    I tried using the below codes. It takes some 4-5 minutes to load the table. Is there any way of optimizing the below code. Can you help me out.

     
    TestRank = IF(ISBLANK([Total Receivables]), BLANK(),
    RANKX (
        SUMMARIZE (
            ALLSELECTED ( Table ),
            Table[CUSTOMER_NO],  Table[CUSTOMER_NAME], Table[COMPANY_CODE], Table[COUNTRY], Table[BUSINESS_UNIT]   
        ),
        CALCULATE ( SUM ( Table[Total Receivables] ) ),
        ,
        DESC,
        DENSE
    ))

    -----------------------------
    Test Running Total =
           VAR CurrentRank = [TestRank]
        VAR Summarizetable =
            CALCULATETABLE (
                SUMMARIZE ( Table, Table[CUSTOMER_NO], Table[CUSTOMER_NAME], Table[COMPANY_CODE],Table[BUSINESS_UNIT],Table[COUNTRY] ),
                ALLSELECTED ( Table )
            )
        VAR small =
            ADDCOLUMNS ( Summarizetable, "@Sales", [Total Receivables], "@Rank", [TestRank] )
        VAR Result =
            SUMX ( FILTER ( small, [@Rank] <= CurrentRank ), [@Sales] )
        RETURN
            Result




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

    hi NikhilChenna 7is there any update on this issue?