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
MissBI_21's avatar
MissBI_21
Icon for Helper II rankHelper II
4 years ago

Hi,

 

Thank you for your response. This isn't quite what I'm looking for and that's because the tables in my BI file are different. I have 3 tables, deals, products and deal proctucts.

Deal table:
Deal ID

Status

Won date

 

Products table: 
Product ID

Product Name

 

Deal Products table:

Deal ID

Product ID

Sum converted (total)

Currently I have the deal products table connected to deals table (deal ID) and products table (product ID).

 

Unfortunately I cannot seem to upload any files.

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi MissBI_21 ,

Could you please create a simplified pbix file with fake data (exclude sensitive data) and share it with me later? The file need to replicate the model(include products, deals and deal product tables) in your fact file... You can refer the following thread to upload your pbix file in your thread. And please provide your expected result with backend logic and special examples. Thank you.

How to upload PBI in Community

Best Regards