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.
im trying to calculate the Average achievment percentage by all sales agent. i have created the achievemnt percentage with a measure: calculate(sum(achievmenet)/sum(monthly target)) and i need to get the average achievment for all agents each month for each channel excluding any agent wih position (retail sales supervisor) . in this case the average achievemnt % should be calculated for all the 9 agents with position (retail sales agent) for the selected channel 'Mahboula' and month =' december2022'
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |