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.