AVERAGE CUSTOMERS PER WEEK

[CESARPULIDOGDL]

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.

[Anonymous · Accepted solution]

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!

[CESARPULIDOGDL]

THANK U, I CAN DO IT WITH YOUR HELP... 🙂

[Jihwan_Kim]

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] )
)