Forum Discussion

cravila83's avatar
cravila83
Copper Contributor
Mar 26, 2022

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

Resources