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"))
SachinNamdeo-20's avatar
SachinNamdeo-20
Icon for Helper II rankHelper II
3 years ago

"Thank you for your valuable suggestion but it gives me blank value, Please suggest me any other measure i also mention my pbi file above"

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Your date table isn't linked to the invoice table. You need to link it on the appropriate field.