Forum Discussion

CESARPULIDOGDL's avatar
CESARPULIDOGDL
Helper I
1 year ago
Solved

AVERAGE CUSTOMERS PER WEEK

I HAVE A TROUBLE

 

I NEED THE AVERAGE CUSTOMER'S OF ANY YEAR-NUMBER WEEK (1 TO 52), THE PERFORMANCE IT'S THAT ONLY TAKE THE DIFFERENTE CUSTOMER'S IN THE LAP ACUM, EXAMPLE:

 

IF JIM MORTENSEN (CUSTOMER) APPEAR EN EVERY WEEK, THE DAX ONLY TAKE LIKE A 1 CUSTOMER EN X PERIOD, I NEED THAT HE COUNT SEVERAL TIMES THAT THE WEEKS HE APPEAR'S.

 

CAN ANYBODY HELPME PLEASE.

 

 

 

average
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi CESARPULIDOGDL,

    Thanks for the reply from Jihwan_Kim.

     

    Could you please share a bit more about your data?

     

    Here is my sample data, if you want to count the average distinct customers per week, you could try the following DAX:

    Average Customers Per Year-Week = 
VAR _CustomersPerWeek =
    SUMMARIZE(
        'Table', 
        'Table'[Year],
        'Table'[WeekNumber],
        "DistinctCustomers", DISTINCTCOUNT('Table'[CustomerID])
    )
RETURN
    AVERAGEX(_CustomersPerWeek, [DistinctCustomers])

    I would be grateful if you could provide me with the pbix file or sample data.

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Qi
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

    Hi,

    I am not sure how your filter context looks like, but please something like below whether it suits your requirement.

     

    expected result measure: =
DIVIDE (
    SUMX ( VALUES ( calendario[Ano+Semana] ), [#cliente compradores >3 cajetillas] ),
    DISTINCTCOUNT ( calendario[Ano+Semana] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi CESARPULIDOGDL,

    Thanks for the reply from Jihwan_Kim.

     

    Could you please share a bit more about your data?

     

    Here is my sample data, if you want to count the average distinct customers per week, you could try the following DAX:

    Average Customers Per Year-Week = 
VAR _CustomersPerWeek =
    SUMMARIZE(
        'Table', 
        'Table'[Year],
        'Table'[WeekNumber],
        "DistinctCustomers", DISTINCTCOUNT('Table'[CustomerID])
    )
RETURN
    AVERAGEX(_CustomersPerWeek, [DistinctCustomers])

    I would be grateful if you could provide me with the pbix file or sample data.

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Qi
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!