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.
Hi
I am trying to set weighted targets for some sales people based on a straight divison of the overall volume increase by the number of sales people.
This is fine except my products are in different categories and so when I try to create the following measure:
WM2 = CALCULATE(SUM('FRY Data'[Target]), 'FRY Data'[Pack Size.1.Product])
I get the following error:
There is not enough information on what you are trying to do. If you want to take some of all product sales then try wrapping second part of calculate inside ALL function.
Please provide images of data
I'm not clear on what you try to achieve with 'FRY Data'[Pack Size.1.Product] - is it supposed to be filter, or something else?
from your description I would assume that the measure should be something like:
[volume increase]/[number of sales people]
but I don't see any relation to that in the code you posted
Many thanks for your reply, what I am trying to do is determine an equal volume target per sales person.
That in itself is relatively straight forward however I have 4 product categories that require different targets.
So in essence what I want to do it take the target value for each product type, divide this by the number of sales people and add that number to their target, seems simple when I write it down!!!
Hi @Qualube,
We need more detailed information, including sample data and desired output, so that we can test for you.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
Hi thanks for the reply I think I will end up dividing the total target equally across the sales team
Many thanks for your reply, what I am trying to do (not very well) is determine an equal volume target per sales person.
That in itself is relatively straight forward however I have 4 product categories that require different targets.
So in essence what I want to do it take the target value for each product type, divide this by the number of sales people and add that number to their target (seem simple when I write it down!!!)
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |