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 

 

Yes, correct😀. Just add other filters with AND (&&).

 

Paul 

matthewtjy's avatar
matthewtjy
Helper I
5 years ago

Hi Paul,

 

Pertaining to this measure, is it possible to have a SUM of 2 measures (Measure1 & Measure 2) and both measures are from 2 different tables and i am unable to combine both tables into 1

 

e.g. Measure1 = CALCULATE(DISTINCTCOUNT([Data Column]),FILTER(ALL(Table1),[Year Column]<=MAX([Year Column])&& [COLOR]<>"BLUE"&& [MATERIAL]<>"Plastic"))

 

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