Forum Discussion
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...
Sorry, had wrong braces. Try:
Measure = CALCULATE(DISTINCTCOUNT([Data Column]),FILTER(ALL(Table),[Year Column]<=MAX([Year Column])&& [COLOR]<>"BLUE"))
Paul
Then try add another filter outside the running total expression.
Measure = CALCULATE(DISTINCTCOUNT(DATA TO COUNT),FILTER(ALL(DATA_TABLE),(DATA DATE)<=MAX(DATA_DATE)), FiLTER(DATA_TABLE, [COLOR]<>"BLUE"))
Paul Zheng _ Community Support Team
I've tried the DAX measure you shared but i've ended up without a cumulative graph now like in the attached photo (refer to blue graph line). Did I do something wrong?