Forum Discussion
Conversion Rate Formula
Hi, I'm trying to calculate the conversion rate of won deals out of deals won and lost by product name and date The formula that I am using is: Conversion Rate = CALCULATE(COUNTROWS('Pipe...
Try this and let me know if you are able to get the result!
Conversion Rate =
Divide(CALCULATE(COUNTROWS('Pipedrive DB'),
'Pipedrive DB'[status] = "Won")
, CALCULATE(COUNTROWS('Pipedrive DB'), Filter(all('Pipedrive DB'),
'Pipedrive DB'[status] = "Won"|| 'Pipedrive DB'[status] = "Lost"))
another thing if you have only won or lost then the last line can be simple Countrows(Table name)