Forum Discussion

MissBI_21's avatar
MissBI_21
Icon for Helper II rankHelper II
4 years ago

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...
Need Help
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
4 years ago
 
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)