Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello There,
Fairly new to Power BI, so I appreciate all the help I can get.
What I'm trying to do is calculate the number of Actions Per Minute, Per User.
I'm honestly a bit of a loss as to where to begin explaining, but maybe the screenshow below will help:
As you can see, with the current filter/slicer, between 04/1 to 08/03, there have been a total of 1.85M actions by each and every user combined.
However, when using the following formula:
You'll notice that the number has changed significantly
Solved! Go to Solution.
Your average is increasing because all the counts for the days are aggregated in your minutes. More days = more actions that occurred in that minute. To solve it you need to add date and hour granularity as follows
AvgActionsPerMinutes =
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous ,
Could you pls upload your .pbix file to onedrive business and share the link with us?
Your average is increasing because all the counts for the days are aggregated in your minutes. More days = more actions that occurred in that minute. To solve it you need to add date and hour granularity as follows
AvgActionsPerMinutes =
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Anonymous very hard to say what is going on? Remove Keepfilter in your average measure, not sure if that is required. if it doesn't work, paste some sample data and we can look into it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |