Sales Conversion %

[budderous]

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.  

[Anonymous · Accepted solution]

% Confirmed = Calculate ( Count ( 'TableName'[ColumnName]), 'TableName'[ColumnName] = "Confirmed") / Count ('TableName'[ColumnName])

Try that with your table and column names and whatever term you are searching for in the column. Set as a percentage under Modeling

[amitchandak]

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 Linkedin

[budderous]

@amitchandak can you assist further, the formula you wrote does not appear to work.