question

CarlosAvila-7763 avatar image
0 Votes"
CarlosAvila-7763 asked

Cummulative 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.

office-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers