Forum Discussion

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

Active dealer count

Dear community, " I want to calculate active dealers count but don't know how satisfied with this condition active dealers are- Active dealer:- Who was appear in more than 3 months in a year is t...
  • SachinNamdeo-20's avatar
    SachinNamdeo-20
    3 years ago

    Thank you sir for your  all valuable suggestions this is done by this measure

    Active Customers = 
VAR SummaryTable =
    ADDCOLUMNS (
        SUMMARIZE ( CUBE_INVOICE, CUBE_INVOICE[SOLD TO PARTNER.PARTNER CODE]),
        "@num months", COUNTROWS ( CALCULATETABLE ( SUMMARIZE ( CUBE_INVOICE, Calendar_new[YM] ) ) )
    )
RETURN COUNTROWS ( FILTER ( SummaryTable, [@num months] >= 3 ) )

    This measure working when we selecct more than 3 month on calender slicer but with this measure we done it for ficial year 

    Active dealer in ficial year = CALCULATE([Active Customers],DATESYTD(Calendar_new[Date],"03/31"))



     

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

SachinNamdeo-20 , I am hoping the dealer and sales are not comma separated. they are in rows.  Use a date  table, but for distinct count use month year from sales table

 

You can create a measures like

 

YTD = CALCULATE(Distinctcount(sales[Month Year]) ,DATESYTD('Date'[Date],"12/31"))

 

GT 3= countx(filter(Values(Sales[Dealer]) , [YTD] >3), [Dealer])

 

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

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

    "Sir actually they are they are comma seprated it means dealer a has sales 10 and dealr b with 20 sales and so on ,and one thing also sales is a column of cube_invioce so i can not use it like your measure with month year .
    these measure gives me value but not not accurate please help sir"