Forum Discussion

budderous's avatar
budderous
Regular Visitor
6 years ago
Solved

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... ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    % 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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

% 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