Forum Discussion

king76's avatar
king76
Frequent Visitor
4 years ago
Solved

Filter several values, how?

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

 
 
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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
     
     

     

2 Replies

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    4 years ago

    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
     
     

     

  • king76's avatar
    king76
    Frequent Visitor
    4 years ago

    Ohhh thank you it was so easy finally!

     

     

     

    Have a nice day