Forum Discussion
Sales Conversion %
% 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.
