Forum Discussion
Target Value for Manager
Hi everyone!
I’m working on a Power BI report where I have the following visuals:
1. A manager-employee hierarchy table with monthly targets.
2. A view of individual employee sales each month, showing the difference between actual sales and target.
3. A table with targets, premiums, and variances at the manager level.
The issue I'm encountering is this: Here an employee (e.g., Employee E2) has no sales in a given month (like February), the sales vs. target column shows as blank. As a result, the manager’s total target for that month reduces due to missing employee sales, which affects the manager's overall target consistency.
My goal is to create a measure that keeps each manager’s target fixed (e.g., M1’s target should remain 2750) regardless of whether some or all employees meet their sales targets.
I’ve been testing various approaches, including formulas with the `ALL()` function and using a Dim_Date created with the `CALENDAR` function. Any suggestions on approaches to achieve this?
Thanks for your insights!
2 Replies
can you share a diagram of what your data model looks like? all wont help as you will need to pad your data in some way, all doesn't exist currently so you have to create that context. you could create a sales value that is 0 if it is blank.
try for your sales measure
sales = sum(sales) + 0
Since I don't know what your data looks like, I tested it by entering some data based on your screenshot, and simply putting the table fields into a matrix visual will do what you want, even without any measures.
Therefore, please provide sample data that fully covers your problem and tell us what efforts you have made so far.
If you don't mind, providing your pbix file is even better. (Remove private data)
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
