Using averages with Time

[Quiqueitcc]

Im having trouble calculating averages such as: average # of users per hour, average # of users per day, average quantity per hour, average to LPNs per hour. I am currently using this formula but am getting unreal results back:

Distinct Operator average per Day =

AVERAGEX(

    KEEPFILTERS(VALUES('2022ChalkHillPickerData'[Date])),

    CALCULATE(DISTINCTCOUNT('2022ChalkHillPickerData'[User])

))

Any help would be greatly appreciated.

[Greg_Deckler]

@Quiqueitcc Try:

Distinct Operator average per Day =
    VAR __Table = 
      SUMMARIZE(
        '2022ChalkHillPickerData',
        [Date],
        "Value",COUNTROWS(DISTINCT('2022ChalkHillPickerData'[User]))
      )
RETURN
    AVERAGEX(__Table, [Value])

[Quiqueitcc]

Using the same formula, but adapted to time and looks like this:

Distinct Operator average per Hr =

AVERAGEX(

    KEEPFILTERS(VALUES('2022ChalkHillPickerData'[Time])),

    CALCULATE(distinctcount('2022ChalkHillPickerData'[User]))

)

[Quiqueitcc]

Do think that same concept will work for time based calculations as well?