Running count total

[Tripb44]

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.

[v-jayw-msft · Accepted solution]

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

[lbendlin]

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