Forum Discussion
Helper IAverage from other subgroup average
Hello,
| Department | Worker | Days at work | Units Sold | Productivity (Units per day) |
| A | John | 3 | 12 | 4 |
| A | Susan | 5 | 15 | 3 |
| B | Angela | 1 | 2 | 2 |
| B | Peter | 5 | 20 | 4 |
| B | Chin | 4 | 12 | 3 |
| Productivity | |
| A | 3,5 |
| B | 3 |
I have a table with data (Department, worker, days, units sold) and a measure "Productivity" (units sold / days at work).
(In reality, i have the report with all the sales per day. Each row represent a sale, with product, quantity,... But for this post, i put just this example)
How can i get the productivity of the department, which has to be the average of all the workers productivity ?
For example, I want the department A to do the average of all the productivities from the workers of that department, not the sum of the itens sold and divided by the working days.
Thks
You can create a new measure to calculate the average productivity for the department.
Measure:
Average of Productivity(Units per day) = AVERAGEX(FILTER(Data,Data[Department]=MAX(Data[Department])),[Productivity(Units per day)])The result is as follows.
Best regards
Rico Zhou
If this post helps,then consider Accepting it as the solution to help other members find it faster.
5 Replies
You can create a new measure to calculate the average productivity for the department.
Measure:
Average of Productivity(Units per day) = AVERAGEX(FILTER(Data,Data[Department]=MAX(Data[Department])),[Productivity(Units per day)])The result is as follows.
Best regards
Rico Zhou
If this post helps,then consider Accepting it as the solution to help other members find it faster.
titusWorks like a charm Anonymous 🙂
- Ashish_Mathur
Super User
- titus
Thk U so much Ashish_Mathur
- Ashish_Mathur
You are welcome. If my reply helped, please mark it as Answer.
