Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative line chart with multiple lines

Currently i have the following graph. It shows the count of registrations (attendeeids) on a specific datediff (the difference in dates between the registration date of the attendee and the start of ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    I'm assuming you are placing the datediff column on you x-axis you need to create the following measure:

     

    CUMULATIVE COUNT =
CALCULATE (
    COUNT ( 'Table'[Atendee] );
    FILTER (
        ALLSELECTED ( 'Table'[DateDiff] );
        'Table'[Datediff] <= MAX ( 'Table'[Datediff] )
    )
)

     

    This should give expected result.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

I'm assuming you are placing the datediff column on you x-axis you need to create the following measure:

 

CUMULATIVE COUNT =
CALCULATE (
    COUNT ( 'Table'[Atendee] );
    FILTER (
        ALLSELECTED ( 'Table'[DateDiff] );
        'Table'[Datediff] <= MAX ( 'Table'[Datediff] )
    )
)

 

This should give expected result.