Forum Discussion

SachinNamdeo-20's avatar
SachinNamdeo-20
Icon for Helper II rankHelper II
3 years ago
Solved

Active customers count

"Dear community, I have 5 years of data at the invoice level. I am trying to calculate the no. of customers who purchased at least 3 times in the current FY and sales quantity of that customers. FY ...
  • johnt75's avatar
    johnt75
    3 years ago

    If you have a date table linked to the fact table you can try

    Active Customers =
VAR SummaryTable =
    ADDCOLUMNS (
        SUMMARIZE ( Sales, Sales[Customer] ),
        "@num months", COUNTROWS ( CALCULATETABLE ( SUMMARIZE ( Sales, 'Date'[Year month] ) ) )
    )
RETURN
    COUNTROWS ( FILTER ( SummaryTable, [@num months] >= 3 ) )
  • SachinNamdeo-20's avatar
    SachinNamdeo-20
    3 years ago
    calculation done
    Active dealer in ficial year =     CALCULATE([Active Customers],DATESYTD(Calendar_new[Date],"03/31"))
Anonymous's avatar
Anonymous
Not applicable
3 years ago
Active Customers =

    COUNTROWS(
    FILTER(
    SUMMARIZE ( 'Customer Sales', 'Customer Sales'[Dealer], 'Customer Sales'[FY],  "@count" , Countrows())
    , [@count] >= 3)
    )
 
If you have Invoicecount more than 1 in any line
 
Active Customers =

    COUNTROWS(
    FILTER(
    SUMMARIZE ( 'Customer Sales', 'Customer Sales'[Dealer], 'Customer Sales'[FY],  "@count" , SUM(InvoiceCount))
    , [@count] >= 3)
    )