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,
I have a data set that has the following dimensions
* Year, Month, Day, Hour
* Region, Branch, Employee, Cashbox
and a fact table with rows per transaction that has a column [Transaction Count] = 1
I am trying to set up a measure that will calculate average transactions per hour per active employee (an employee that has at least one transaction in that hour on that day). This needs to drill down appropriately. I figured I'd have a measure for SUM([Transaction Count]) and find a count of tellers with transaction each hour and just do simple division, but I am having problems with that second part. Do I need a summary table? Could someone help point me in the right direction?
Solved! Go to Solution.
Hi @rlussky,
You need create a summary table grouped by each employee per hour, and use Averagex function, just like:
AVERAGEX(
filter_table,
[[Transaction Count]
)
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @rlussky,
Is your issue solved?
If the issue has been solved, please adopt the solution to help others.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi @rlussky,
You need create a summary table grouped by each employee per hour, and use Averagex function, just like:
AVERAGEX(
filter_table,
[[Transaction Count]
)
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Thanks @v-xulin-mstf. The summary table is definitely the diretion I needed to go. I've been away from PBI for almost a year so I'm a bit rusty!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |