Forum Discussion
Sales Conversion %
Hi
I need show the sale conversion rate on the leads my sales guys are taking. They have about 10 different statuses that they currently use:
Quote Created, Live, New, Sale Completed etc... All of these are in the column 'Oppurtunity Status'. I simply need to know the % of sales confirmed against total leads for each sales person preferable in a table or bar chart.
Could also do with some help on how to make a value column show as a count column.
3 Replies
Try something like
% converted = var sales closed = calculate(count(Oppurtunity[ID]]),filter(Oppurtunity,Oppurtunity['Oppurtunity Status']="Sale Completed ")) var Total leads = calculate(count(Oppurtunity[ID]]))//Add a filter some stage need to be removed return divide([sales closed ],[Total leads])Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedinamitchandak can you assist further, the formula you wrote does not appear to work.
