Filter several values, how?

[king76]

Hello,

I'm using a piece of code I found on the Internet that works very well, which allows me to display the number of records added cumulatively on a graph: 

Instead of displaying the total of all records, I want to display a curve for each activity area. I don't know in my formula how to filter against another field (activity).

The formula : 

data =
CALCULATE (
     COUNTX(Users,[date]),
     FILTER (ALL('User (by date)'[date]), 'User (by date)'[date] <= MAX('User (by date)'[date])
     )
)

My USERS table contains a DATE field and an ACTIVITY field
The other table USER (By date), it's a copy of my USER table which contains only dates.

Can you help me?

Thanks

[king76]

Ohhh thank you it was so easy finally!

Have a nice day

[ValtteriN · Accepted solution]

Hi,

Could you specify a bit more what do you mean by " I want to display a curve for each activity area"?
Do you mean you want to have a running total calculation for each activity? If that is what you are trying to do you can add the "activity" field either to legend or small multiples part of your line graph. Also for running totals without YTD I recommend using the following structure: 

RT with selected time period =

var _edate = MAX('Calendar example'[Date]) return

CALCULATE(SUM('Quarter calculations'[Value]),

'Calendar example'[Date]<=_edate,ALL('Calendar example'))
//You can replace sum with count if that is what you need