AVERAGE CUSTOMERS PER WEEK

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!