average of distinct date

by

#I have a column that contains dates, and some dates are repeated. Each time it’s repeated, it means it’s a new request. I want to display the average number of requests per date. I want to know how many requests we receive per day on average. How can I achieve this, please?

NombreDemandesPourDate = 
CALCULATE(
    COUNTROWS('demande'),
    FILTER(
        'demande',
        'demande'[date_insert] = 'demande'[date_insert]
    )
)

Try the following as a Measure:

NombreDemandesPourDate = 
  AVERAGEX(
    DISTINCT('demande'[date_insert]),
    CALCUALTE(COUNTROWS('demande'))
  )

Leave a Comment