Forum Discussion
Multiply one conversion by another
Hi,
I'm trying to work out what extra orders I could get if the conversion rate was at a higher level. For example, let's say I have a conversion rate of 50% on product 1 and 30% on product 2. If product 2 converted at product 1's rate, how many extra orders could I expect to see? My table is similar to the one below:
| Type | Users | Orders | Conversion | Extra Orders |
| Product 1 | 100 | 50 | 50% | |
| Product 2 | 100 | 30 | 30% | 20 |
The issue I think is because when I'm trying to apply the conversion rate from product 1, it's already filtered to that product so can't apply it to product 2.
Thanks in advance for any help!
Anonymous
Can you please see attached workspace.
Created the following 2 new measures that you can add to the report:
Percent PRD1 = CALCULATE(SUM(Sheet1[Orders]), Sheet1[Type] = "Product 1") / CALCULATE(SUM(Sheet1[Users]), Sheet1[Type] = "Product 1")
Extra Order = ([Percent PRD1] * SUM(Sheet1[Users])) - SUM(Sheet1[Orders])
2 Replies
- themistoklisCommunity Champion
Anonymous
Can you please see attached workspace.
Created the following 2 new measures that you can add to the report:
Percent PRD1 = CALCULATE(SUM(Sheet1[Orders]), Sheet1[Type] = "Product 1") / CALCULATE(SUM(Sheet1[Users]), Sheet1[Type] = "Product 1")
Extra Order = ([Percent PRD1] * SUM(Sheet1[Users])) - SUM(Sheet1[Orders])
- AnonymousNot applicable
Thank you themistoklis.