Forum Discussion
cravila83
Mar 26, 2022Copper Contributor
Cumulative Distinct Count with multiple filters Power Pivot
I'm trying to run a cumulative or running total for distinct count with power pivot measures.
I found the below formulas work, but I need one that filters for some columns but not all. Need the cumulative count since first available date regardless of the date filter but need to keep the filters for the other columns active. Any ideas on how to accomplish this?
ALL SELECTED
calculate(DISTINCTCOUNT([ID]), FILTER(ALLSELECTED(Range),Range[Week Of] <= max(Range[Week Of])))
ALL
calculate(DISTINCTCOUNT([ID]), FILTER(ALL(Range),Range[Week Of] <= max(Range[Week Of])))
I need a ALL Selected except if exist.
Thanks in advance.
No RepliesBe the first to reply