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 

     

     

Anonymous's avatar
Anonymous
Not applicable
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

    Thank Paul! This works like a charm!

     

    Just to check, if i need to include extra filters e.g. "Material" is not "Plastic", i could just add on a filter as such correct?

     

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