Average Number of Occurrences based on Day

[NB689]

Hello,

I am looking to create a measure that will supply me with a "Average Logins Per Day Per User".

My data set looks like this:

User ID	Date
A	7/19/2022
A	7/19/2022
A	7/20/2022
A	7/19/2022
B	7/19/2022
B	7/19/2022
B	7/19/2022
C	7/20/2022

The logic that I am planning to use to provide the average logins per day per user is: Total number of logins (8)/divided by number of days (2)/divided by number of users (3). So in this case, our number would be 1.3.

I would then plan to create a card that has the 1.3 number value, and I would add slicers for the user id and date. If I selected my user ID slicer to user "A" the number that I would expect to see would be 2.

Thank you

[vapid128 · Accepted solution]

 logins per day=

var _days = max([Date])-min([Date])+1

return 

DIVIDE(

    countrow(table),

    discountcount([User ID]) * _days

)

[NB689]

This is working great. Thank you!

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

Avg login per day per user: =
DIVIDE (
    DIVIDE ( COUNTROWS ( Data ), COUNTROWS ( VALUES ( Data[Date] ) ) ),
    COUNTROWS ( VALUES ( Data[User ID] ) )
)