The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
Solved! Go to Solution.
logins per day=
var _days = max([Date])-min([Date])+1
return
logins per day=
var _days = max([Date])-min([Date])+1
return
This is working great. Thank you!
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] ) )
)
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |