Forum Discussion

kryer89's avatar
kryer89
New Member
1 year ago
Solved

Cumulative count

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/2...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.