Cumulative count

[kryer89]

Hi,

i'm trying to plot a line chart with cumulative count of rows but it's not working.

my data is like:

ID	StartDate
ID1	02/10/2023
ID2	02/04/2024
ID3	null
ID4	05/10/2023
ID5	12/01/2024
ID6	12/01/2024
ID7	15/05/2024

I want to plot a chart with this data

Count	1	2	4	6
date	02/10/2023	05/10/2023	12/01/2024	15/05/2024

but I cannot figure out how to do it, I've tried with this measure

CALCULATE (
    COUNTROWS(  'MASTER' ),
    FILTER (
        ALL ( 'MASTER' ),
        'MASTER'[StartDate] <= MAX ( 'MASTER'[StartDate] )
    )
)

 but what I get is the cumulative of the cumulative, like

Count	1	3	7	13
date	02/10/2023	05/10/2023	12/01/2024	15/05/2024

Is there any way I can fix it?

Thanks!

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[Anonymous · Accepted solution]

Hi @kryer89 ,

Please try code as below.

Measure = 
CALCULATE (
    COUNTROWS(  'MASTER' ),
    FILTER (
        ALLSELECTED( 'MASTER' ),
        'MASTER'[StartDate] <= MAX ( 'MASTER'[StartDate] ) && MASTER[StartDate]<>BLANK()
    )
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arul]

@kryer89 ,

Which count are you taking from the data given?