Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

parry2k's avatar
parry2k
Super User
3 years ago

Anonymous logically you should have date dimension in the model to work with dates, in the meantime you can use the following measure:

 

Distinct Customer Count with Revenue = 
CALCUALTE ( 
    DISTINCTCOUNT ( Table[Customer] ),
    Table[Revenue] > 0 
)

👉 Learn Power BI Subscribe to our YT channel - @PowerBIHowTo