Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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:

 

TypeUsersOrdersConversionExtra Orders
Product 11005050% 
Product 21003030%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

  • themistoklis's avatar
    themistoklis
    Community 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])