feature comparison
1 Topic
Benchmark measure to compare lead quality of one sales rep with others who receive the same leads
Hi! I want to create a measure that will help me to compare one sales rep results with others, based on the lead quality they work with. The background: Each sales rep receives different leads, based on 3 parameters: lead value, lead category, lead type. Throughout the time, the proportion may differ. So step 1 will determine the lead quality combo per sales rep. I did it with TOPN function for each parameter separately: Top1 Lead Potential per SaleRep = TOPN(1, all('table1'[Lead Potential]), Calculate(Counta('table'[Lead Potential])), DESC) It returns string value, f.e. 'Medium' in this case. Step 2 should be to calculate AVG number of leads per sales rep who have the same TOP1 Lead Potential, TOP1 lead category and TOP1 lead type. Any ideas how to proceed with step 2?Solved645Views0likes2Comments