Simple Running Count

[fabdata1207]

Hi all

I need to do a simple running total with sort by date

in the below sample I need to create a measure as the same of Running Total and that counts the CODE and sort based on Date exactly like the Running Total column

CODE	Date	Running Total
B	1/07/2021	1
A	4/07/2021	2
A	7/07/2021	2
D	9/07/2021	3
C	9/07/2021	4
F	15/07/2021	5
F	20/07/2021	6
F	20/07/2021	6
E	20/07/2021	6
Total	31/07/2021	6

is that possible ?

Thanks all

[Ashish_Mathur]

Hi,

There are duplicate combinations of CODE and Date i.e. F and 20/7/2021.  Is this by design?  I ask because when these 2 columns will be dragged to the visual, you will see only 1 row for F and 20/7/2021.  Is there any other column you have in your dataset which makes the CODE and Date combination unique?  If not, then would you want a calculated column solution instead of a measure?

[ryan_mayu · Accepted solution]

@fabdata1207 

you can try this

Measure = 
VAR _total=CALCULATE(DISTINCTCOUNT('Table'[CODE]),FILTER(all('Table'),'Table'[Date]<=max('Table'[Date])))
return if (ISFILTERED('Table'[CODE]),_total, DISTINCTCOUNT('Table'[CODE]))