Forum Discussion

CESARPULIDOGDL's avatar
CESARPULIDOGDL
Icon for Helper I rankHelper 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 (CUS...
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!

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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] )
)