Total Sum Sales Target by Sales Rep

[ADSL]

Dear All BI Expert,

As per screenshot attachment I am trying to total sum sales target by sales rep but when I create the measure below, it's not by sales rep and get the grand total. Could you please kindly assist to check and advise?

Measure:  Total Sales Target = SUM('Sales Target'[Target_Amount])

[v-rzhou-msft · Accepted solution]

Hi @ADSL ,

According to your statemenet, I know that you want to sum the sales target grouping by Sales Rep. Here I suggest you to try ALLEXCEPT() function in your code.

Total Sum Sales Target by Sales Rep =
CALCULATE (
    SUM ( 'Sales Target'[Target_Amount] ),
    ALLEXCEPT ( 'Sales Target', 'Sales Target'[SalesRep Name] )
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ADSL]

Hi @v-rzhou-msft ,

Thank you for your feedback. For your measure I have been tried but it's not working.

After review and try again then it's working now.

Best Regards,

[speedramps]

We want to help you but your description is too vaugue.

There is no such column as " sales target by sales rep" in you exmple !

Also you are asking us to provide a solution without providing the underlying dataset structure ... we are not mind readers and dont know how your data is organised, which will determine the solution

Please write it again clearly.

Provide example input data as table text (not a screen print) so we can import the data to build a soution for you.
Also provide the example desired output, with a clear description of the process flow.

Don't care not to share private data.

Take care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time and effort into writing clear problem descriptions.

Vaugue descriptions waste your time and ourtime.

Look foward to helping you when the above information is forthcoming.

[ADSL]

Hi @speedramps ,

Thank you for feedback and advise. I will follow for next ticket/request.

Best Regards,