Forum Discussion
Post ProdigyTotal Sum Sales Target by Sales Rep
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserWe 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,
