Forum Discussion

matthewtjy's avatar
matthewtjy
Helper I
5 years ago
Solved

Cumulative Distinct Count by Year

Hi, I've used the measure "Measure = CALCULATE(DISTINCTCOUNT(DATA TO COUNT),FILTER(ALLSELECTED(DATA_TABLE),(DATA DATE)<=MAX(DATA_DATE)))" to plot a cumulative graph.   For example's sake, I've simp...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    matthewtjy 

    Sorry, had wrong braces. Try:

    Measure = CALCULATE(DISTINCTCOUNT([Data Column]),FILTER(ALL(Table),[Year Column]<=MAX([Year Column])&& [COLOR]<>"BLUE"))

     

     

    Paul 

     

     

matthewtjy's avatar
matthewtjy
Helper I
5 years ago

Hi, hope someone would be able to help out, have included screenshots below for further explanation.

 

Based on all my data since 2014, the cumulative count for the blue line is 903 as of May 2021 (see first picture).

 

However, once i filter the results to show the last 13 months, the blue line only shows 227 as of May 2021 (see second picture).

 

Is there a way to show the cumulative count to count since 2014 even with the silcer to only show last 13 months?

 

Thanks!