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.