benchmarking
2 Topics
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?Solved638Views0likes2Comments
dynamic filtering of a virtual table using a measure
Hello I'm looking for advice on an issue (I'm new to Power BI). I have data that is used for benchmarking. The relevant table contains both the data to be benchmarked (dataA) and the data against which it will be benchmarked (dataB). To separate the data so that dataA is not included in dataB, as it's not good practice to include the data to be benchmarked in the data that it will be benchmarked against, I have created a virtual table that is filtered by a measure [Active Org]. The measure is controlled by a slicer that selects the client allowing us to see their data (dataA) in comparison with dataB. This virtual table it relatively straightforward: VirtualTable1 = filter(DataTable,DataTable[OrgID] = [Active Org]) the table itself doesn't appear to physically filter, but measures based on the table respond to the slicer. What I'd like to do it create the corresponding table containing dataB using the opposite command, such as: VirtualTable2 = filter(DataTable,DataTable[OrgID] <> [Active Org]) but . . . I can't get this to work at all. Can anybody advice here, please? Kind regardsSolved912Views0likes4Comments