Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Report creation with dynamic values

Hi, I have a requirement with 2 data collections(A to E and L to P), shown below. It has to 2 parameters in column 'I' and 'T' as Paywall Users and Conversion, the user wants to enter values into t...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    You can create multiple what-if parameters and apply it in calculation.

    Create these measures to compare in line chart:

    Revenue1 = MIN('Paywall Users'[Paywall Users]) * MAX('Conversion'[Conversion]) * MIN('RATE'[RATE])  * SELECTEDVALUE(Table1[Retention]) * SELECTEDVALUE(Table1[LTV])
    Revenue2 = MAX('Paywall Users'[Paywall Users]) * MIN('Conversion'[Conversion]) * MAX('RATE'[RATE])  * SELECTEDVALUE(Table2[Retention]) * SELECTEDVALUE(Table2[LTV])

    Start Estimate value:

    Start Estimate = SELECTEDVALUE('Paywall Users'[Paywall Users]) * SELECTEDVALUE(Conversion[Conversion])

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

You can create multiple what-if parameters and apply it in calculation.

Create these measures to compare in line chart:

Revenue1 = MIN('Paywall Users'[Paywall Users]) * MAX('Conversion'[Conversion]) * MIN('RATE'[RATE])  * SELECTEDVALUE(Table1[Retention]) * SELECTEDVALUE(Table1[LTV])
Revenue2 = MAX('Paywall Users'[Paywall Users]) * MIN('Conversion'[Conversion]) * MAX('RATE'[RATE])  * SELECTEDVALUE(Table2[Retention]) * SELECTEDVALUE(Table2[LTV])

Start Estimate value:

Start Estimate = SELECTEDVALUE('Paywall Users'[Paywall Users]) * SELECTEDVALUE(Conversion[Conversion])

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.