Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Active Customers by day

I currently count active and unactive customers based on customers who have been in +/- 100 days. My measures only give me a current day view of the active customers. Would it be possible to get a me...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    I'm sorry. I modify the measure.

    active = 
COUNTX (
    FILTER (
        ALL ( Customers ),
        Customers[CURRENT last order]
            >= SELECTEDVALUE ( 'Table'[Date] ) - 100
            && [CURRENT last order] <= SELECTEDVALUE ( 'Table'[Date] )
    ),
    [customerID]
) + 0
    inactive = 
COUNTX (
    FILTER (
        ALL ( Customers ),
        Customers[CURRENT last order]
            < SELECTEDVALUE ( 'Table'[Date] ) - 100
            || [CURRENT last order] > SELECTEDVALUE ( 'Table'[Date] )
    ),
    [customerID]
) + 0

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

According to your last reply, You need to create a single date list as slicer and create two measure to calculate active and inactive.

Like this:

Table = DISTINCT('Date'[Date])
active = COUNTX(FILTER(ALL(Customers),DATEDIFF(SELECTEDVALUE('Table'[Date]),[CURRENT last order],DAY)<=100),[customerID])+0
inactive = COUNTX(FILTER(ALL(Customers),DATEDIFF(SELECTEDVALUE('Table'[Date]),[CURRENT last order],DAY)>100),[customerID])+0

 

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Doesn't look like that will work. If you zoom forward to today, there should be 1 active customer (made order on 3/1/21) and 4 inactive. 

 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

     

    Did you download my file? Have you used new date column as slicer and use it in table instead of old?

     

    Best Regards

    Janey Guo

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yeah that picture was from your file. Zoom to today and there should only be one active