Forum Discussion

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago
Solved

Running Totals

Hello All,   This is a sample of my data: Anyone know what I should do to get the running totals for the Users? Mind you, my actual data is over 43,000 rows.   I tried to upload a sample ...
  • techies's avatar
    techies
    1 year ago

    Hi e175429 please try this

     

    Running Total =
    CALCULATE (
        COUNTROWS(payments),
        FILTER (
            ALLEXCEPT ( payments, payments[User] ),  
            payments[PaidDate]<= MAX ( payments[PaidDate] )
        )
    )
     

     

     

     

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
1 year ago

Hello e175429,

 

Could you please try the following approach:

Running Total per User :=
VAR CurrentDate = MAX ( 'Fact'[PaidDate] )
RETURN
CALCULATE (
    COUNTROWS ( 'Fact' ),
    FILTER (
        ALLSELECTED ( 'Fact'[PaidDate] ),
        'Fact'[PaidDate] <= CurrentDate
    )
)
  • e175429's avatar
    e175429
    Icon for Helper IV rankHelper IV
    1 year ago

    Hey,

     

    Thank you for your response. I've created the measure but I'm not sure how to graph this.

    This is what I get:

    Which is not exactly what I am looking for. 


    In the table, I want the running totals for everyone, and then when I put a filter on, I would like the running total for that one individual. 

     

    I have already created a date table: