Forum Discussion

Tripb44's avatar
Tripb44
Helper II
5 years ago
Solved

Running count total

I am need a running total for distinct counts.  Desired output for example, on Feb 10, the running total would be 290 ect.  Below is the current measure that is returning the normal count per day.

 

 

 

 

 

Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Tripb44 ,

     

    You could use SUMX() function.

    sample data for your reference.

    Measure 2 = SUMX(FILTER(ALL('Table'[day]),'Table'[day]<=MAX('Table'[day])),[Measure])

     

     

    Best Regards,

    Jay

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Please provide sample data in usable format (not as a picture) .

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Tripb44 ,

     

    You could use SUMX() function.

    sample data for your reference.

    Measure 2 = SUMX(FILTER(ALL('Table'[day]),'Table'[day]<=MAX('Table'[day])),[Measure])

     

     

    Best Regards,

    Jay