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 

 

Try add the color filter inside the running total expression.

Measure = CALCULATE(DISTINCTCOUNT(DATA TO COUNT),FILTER(ALL(DATA_TABLE),[DATA DATE]<=MAX(DATA_DATE) && [COLOR]<>"BLUE"))

 

 

Paul Zheng _ Community Support Team

matthewtjy's avatar
matthewtjy
Helper I
5 years ago

This formula gives the error "The MAX function only accepts a column reference as an argument"

 

Is there another workaround to this?

 

Thanks in advance!