How to count active customer numbers who has sales large than 4 units every month

[Anonymous]

Hi Folks,

Anyone know how to calculate active customer numbers. The active customer must to have at least 4 units sales every month.

Thank you.

[harshnathani]

Hi @Anonymous ,

You can check if this works

Quantity 1M =
CALCULATE (
    SUM ( 'Table'[Purchase Quantity] ),
    DATESINPERIOD (
        'Calendar'[Date],
        MAX ( 'Calendar'[Date] ),
        -1,
        MONTH
    )
)

Active Customers =
VAR _activeCusts =
    FILTER (
        Customers,
        [Quantity 1M] > 4
    )
RETURN
    COUNTROWS ( _activeCusts )

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @Anonymous 

It could something like this:

MoreThan4 = 
var _NofMonths = DISTINCTCOUNT(Data[Month])
var _4Units = calculate( DISTINCTCOUNT(Data[Month]), Data[Qty] >=4)

return If (_4Units>=_NofMonths, "Active", "Not Active")

Jan if this is a solution for you, don't forget to mark it as such. thanks

[amitchandak]

@Anonymous , refer if this can ehlp

https://community.powerbi.com/t5/Desktop/Churn-Rate-lost-Customer/m-p/1173754#M529196
https://blog.enterprisedna.co/new-vs-existing-customers-advanced-analytics-w-dax/
https://www.sqlbi.com/articles/computing-new-customers-in-dax/