Forum Discussion
Customer count over time
Hello everyone, I am in need of some help and haven't been able to figure this out. I have a list of customers from Dec 2022, Jan 2023 and Feb 2023, what I need is to get a distinct count of thes...
Hi Anonymous ,
You can also try the following dax:
Measure:
Measure = CALCULATE( DISTINCTCOUNT('Table'[Revenue Date]), FILTER(ALL('Table'), 'Table'[Customer ID]=MAX('Table'[Customer ID])&&'Table'[Revenue]>0),'Table'[Revenue Date])Calculated column:
Column = CALCULATE( DISTINCTCOUNT('Table'[Revenue Date]), FILTER(ALL('Table'), 'Table'[Customer ID]=EARLIER('Table'[Customer ID])&&'Table'[Revenue]>0),'Table'[Revenue Date])Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
You can also try the following dax:
Measure:
Measure =
CALCULATE(
DISTINCTCOUNT('Table'[Revenue Date]),
FILTER(ALL('Table'),
'Table'[Customer ID]=MAX('Table'[Customer ID])&&'Table'[Revenue]>0),'Table'[Revenue Date])Calculated column:
Column =
CALCULATE(
DISTINCTCOUNT('Table'[Revenue Date]),
FILTER(ALL('Table'),
'Table'[Customer ID]=EARLIER('Table'[Customer ID])&&'Table'[Revenue]>0),'Table'[Revenue Date])Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly