Forum Discussion

pmcard97's avatar
pmcard97
New Member
8 years ago
Solved

Cumulative Transaction Count

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?

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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] )
    )
)

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    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] )
    )
)