Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
% 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
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
@amitchandak can you assist further, the formula you wrote does not appear to work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |