Cumulative Transaction Count

[pmcard97]

I have a table of transactions with a transaction date.  I want to create a line graph that displays the cumulative count of transactions.

I created a new column as:

Cumulative Count = CALCULATE(
                    COUNTROWS(master_roster),
                    FILTER( ALLSELECTED(master_roster), 
                            master_roster[enrollmentDate] <= MAX(master_roster[enrollmentDate]) )
            )

For some reason, the filter does not seem to be working.  Every data row in the table has Cumulative Count = the total number of rows. When I create a line graph with [enrollmentDate] on the Axis and Maximum of [Cumulative Count] in the values I get the total count for all dates.

What am I doing wrong?

[Ashish_Mathur]

Hi @pmcard97,

Show your dataset and the expected result.

[Zubair_Muhammad · Accepted solution]

@pmcard97

Hi,

If you are using a calculated column, you need to replace "Max" with "Earlier"

=
CALCULATE (
    COUNTROWS ( master_roster ),
    FILTER (
        master_roster,
        master_roster[enrollmentDate] <= EARLIER ( master_roster[enrollmentDate] )
    )
)