Filter Columns

[Qualube]

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:

[kamran_bsh]

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

[Stachu]

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

[Qualube]

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!!!

[v-yulgu-msft]

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

[Qualube]

Hi thanks for the reply I think I will end up dividing the total target equally across the sales team

[Qualube]

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!!!)