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.
Goal:
Track sales team performance by their ability to hit their quotas (Forecast) for the year. The chart will show what their quota (forecast) is for each month, actual sales for each month (revenue), and the average monthly target needed to achieve their end of year quotas (high level shows them at current pace this value is what they need to average for the ensuing months).
Problem:
I'm having difficulty with creating a measure for a dynamic Monthly Target. This value should update each month based on actual sales (Revenue) achieved by that specific salesperson. The New Monthly Target Measure below does not work as I would like, and I'm currently stuck.
Measures created thus far:
Data:
Solved! Go to Solution.
Maybe the issue is with my Measures that are calculating "totals". It appears the total measure isn't looking at all the months but instead is only looking at each row. Perhaps I need to use the CALCULATE function?
Desired results assuming I throw one salesperson into a table or matrix show below (images show the progress as the Today month changes). As revenue is generated, the monthly target will adjust.
For Jan:
For Feb:
For March:
Please provide sample data in usable format (not as a picture) .
https://drive.google.com/drive/folders/1TRYTTgoKDAVzHOr4g85dcEBLPxKZH9Ld?usp=sharing
Thanks for the response. Link above includes the .pbix & data file.
Can you share your expected output?
Maybe the issue is with my Measures that are calculating "totals". It appears the total measure isn't looking at all the months but instead is only looking at each row. Perhaps I need to use the CALCULATE function?
Desired results assuming I throw one salesperson into a table or matrix show below (images show the progress as the Today month changes). As revenue is generated, the monthly target will adjust.
For Jan:
For Feb:
For March:
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 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |